{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Analysis","Commentary","Appendix","Rebar Area & Centroid","About","!! Hide this!!-Input_info_model"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":12,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Analysis","index":0,"n_rows":1000,"n_cols":35,"rows_kept":1000,"cut":false,"hidden":false,"merged":[[481,13,481,18],[202,7,202,8],[203,7,203,8],[204,7,204,8],[205,7,205,8],[206,7,206,8],[207,7,207,8],[208,7,208,8],[209,7,209,8],[210,7,210,8],[232,7,232,8],[233,7,233,8],[234,7,234,8],[235,7,235,8],[236,7,236,8],[214,7,214,8],[215,7,215,8],[216,7,216,8],[217,7,217,8],[219,7,219,8],[469,1,469,8],[427,5,428,5],[429,1,452,1],[453,1,464,1],[200,16,201,16],[200,17,201,17],[212,12,213,12],[426,2,426,4],[105,5,105,7],[106,5,106,7],[107,5,107,7],[108,5,108,7],[298,1,298,5],[152,1,152,3],[299,1,299,2],[352,3,352,4],[262,7,262,8],[354,8,354,9],[357,8,357,9],[356,8,356,9],[358,8,358,9],[216,9,239,9],[220,7,220,8],[213,7,213,8],[237,7,237,8],[238,7,238,8],[298,12,298,13],[220,2,221,2],[5,10,5,11],[59,5,62,8],[120,1,120,5],[125,1,125,8],[76,5,76,8],[79,5,79,7],[80,5,80,7],[81,5,81,7],[82,5,82,7],[104,5,104,8],[109,5,109,7],[35,1,35,2],[5,2,5,3],[14,1,14,8],[35,3,35,6],[30,1,30,6],[80,1,80,2],[21,1,21,5],[22,1,22,5],[19,1,19,5],[78,1,78,2],[31,1,31,3],[79,1,79,2],[76,1,76,3],[314,1,314,8],[366,3,366,4],[361,3,361,4],[306,3,308,3],[363,3,363,4],[300,7,311,7],[226,7,226,8],[362,3,362,4],[355,8,355,9],[245,7,245,8],[246,7,246,8],[247,7,247,8],[248,7,248,8],[258,7,258,8],[259,7,259,8],[260,7,260,8],[261,7,261,8],[239,7,239,8],[240,1,242,1],[240,2,242,2],[204,16,205,16],[234,17,235,17],[212,16,213,16],[220,12,221,12],[244,16,245,16],[232,16,233,16],[210,16,211,16],[240,16,241,16],[212,17,213,17],[204,12,205,12],[222,17,223,17],[236,17,237,17],[242,17,243,17],[206,17,207,17],[208,17,209,17],[228,17,229,17],[220,17,221,17],[230,17,231,17],[232,17,233,17],[226,17,227,17],[216,17,217,17],[218,17,219,17],[214,16,215,16],[218,16,219,16],[224,16,225,16],[216,16,217,16],[220,16,221,16],[230,16,231,16],[228,16,229,16],[378,5,379,5],[395,3,395,5],[208,16,209,16],[376,1,376,3],[368,8,368,9],[363,8,363,9],[362,8,362,9],[364,8,364,9],[369,3,369,4],[246,16,247,16],[299,8,299,10],[352,8,352,9],[244,12,245,12],[249,7,249,8],[250,7,250,8],[251,7,251,8],[252,7,252,8],[351,8,351,9],[221,7,221,8],[222,18,223,18],[216,18,217,18],[210,18,211,18],[234,12,235,12],[238,12,239,12],[238,16,239,16],[242,16,243,16],[240,17,241,17],[238,17,239,17],[224,17,225,17],[216,12,217,12],[230,12,231,12],[214,17,215,17],[210,17,211,17],[240,12,241,12],[222,12,223,12],[226,12,227,12],[234,18,235,18],[232,18,233,18],[226,18,227,18],[218,18,219,18],[224,18,225,18],[230,18,231,18],[226,16,227,16],[427,2,428,2],[427,3,428,3],[427,4,428,4],[351,3,351,4],[347,8,347,9],[371,3,371,4],[378,6,379,6],[242,12,243,12],[371,8,371,9],[370,8,370,9],[361,8,361,9],[360,8,360,9],[368,3,368,4],[366,8,366,9],[365,8,365,9],[427,6,428,6],[396,6,397,6],[374,1,374,8],[367,8,367,9],[246,12,247,12],[378,1,379,1],[353,8,353,9],[349,8,349,9],[255,7,255,8],[202,12,203,12],[189,7,189,8],[198,7,198,8],[85,1,85,8],[190,7,190,8],[139,1,139,3],[143,1,143,4],[195,7,195,8],[138,1,138,3],[148,1,148,4],[200,12,201,12],[180,7,180,8],[193,7,193,8],[194,7,194,8],[153,1,153,3],[196,7,196,8],[199,7,199,8],[201,7,201,8],[130,1,130,3],[88,1,89,1],[197,7,197,8],[224,12,225,12],[228,12,229,12],[214,12,215,12],[218,12,219,12],[309,3,311,3],[208,12,209,12],[359,8,359,9],[238,2,239,2],[263,7,263,8],[350,8,350,9],[299,3,299,5],[303,3,305,3],[349,3,349,4],[347,3,347,4],[348,3,348,4],[242,7,242,8],[243,7,243,8],[244,7,244,8],[297,1,297,2],[212,7,212,8],[223,7,223,8],[224,7,224,8],[225,7,225,8],[356,3,356,4],[218,2,219,2],[222,7,222,8],[354,3,354,4],[355,3,355,4],[4,4,4,5],[4,10,4,11],[206,12,207,12],[210,12,211,12],[81,1,81,2],[129,1,129,4],[87,1,87,5],[59,1,60,4],[24,8,28,8],[18,1,18,5],[20,1,20,5],[6,2,6,3],[4,2,4,3],[5,6,5,8],[6,6,6,8],[4,6,4,8],[198,12,199,12],[16,1,16,5],[24,6,27,6],[204,9,215,9],[218,7,218,8],[198,15,199,15],[1,1,1,8],[15,1,15,5],[104,1,104,3],[50,5,50,8],[158,1,158,8],[145,1,145,3],[216,2,217,2],[145,5,147,6],[211,7,211,8],[146,1,146,3],[150,1,150,2],[191,7,191,8],[192,7,192,8],[200,7,200,8],[132,1,132,3],[17,1,17,5],[131,1,131,3],[88,2,88,3],[88,4,88,5],[131,5,133,6],[5,4,5,5],[6,4,6,5],[8,1,8,5],[77,5,77,7],[78,5,78,7],[198,16,199,16],[197,12,197,24],[198,24,199,24],[38,15,38,17],[127,1,127,3],[32,1,32,3],[121,1,121,4],[122,1,122,4],[212,20,213,20],[212,21,213,21],[212,22,213,22],[77,1,77,2],[144,1,144,3],[141,1,141,3],[208,23,209,23],[202,24,203,24],[204,24,205,24],[206,24,207,24],[208,24,209,24],[202,16,203,16],[192,9,203,9],[200,24,201,24],[198,19,198,20],[155,1,155,3],[176,1,176,8],[179,7,179,8],[178,3,178,8],[206,16,207,16],[204,17,205,17],[198,21,198,23],[180,9,191,9],[202,17,203,17],[210,24,211,24],[212,24,213,24],[202,23,203,23],[202,22,203,22],[202,21,203,21],[198,18,199,18],[198,13,199,13],[200,21,201,21],[198,14,199,14],[198,17,199,17],[202,20,203,20],[200,22,201,22],[200,23,201,23],[206,19,207,19],[204,18,205,18],[204,19,205,19],[206,21,207,21],[206,22,207,22],[206,23,207,23],[206,20,207,20],[204,20,205,20],[210,23,211,23],[204,23,205,23],[206,18,207,18],[398,1,409,1],[214,23,215,23],[222,20,223,20],[222,21,223,21],[222,22,223,22],[222,23,223,23],[204,1,215,2],[222,2,223,2],[396,7,397,7],[240,7,240,8],[241,7,241,8],[227,7,227,8],[228,7,228,8],[229,7,229,8],[230,7,230,8],[231,7,231,8],[226,23,227,23],[212,23,213,23],[210,20,211,20],[210,21,211,21],[210,22,211,22],[367,3,367,4],[365,3,365,4],[364,3,364,4],[216,22,217,22],[216,23,217,23],[218,20,219,20],[218,21,219,21],[218,22,219,22],[218,23,219,23],[216,19,217,19],[218,19,219,19],[224,19,225,19],[222,19,223,19],[242,24,243,24],[234,23,235,23],[220,20,221,20],[224,20,225,20],[224,21,225,21],[224,22,225,22],[238,23,239,23],[228,20,229,20],[228,21,229,21],[228,22,229,22],[228,23,229,23],[220,21,221,21],[220,22,221,22],[220,23,221,23],[226,20,227,20],[230,20,231,20],[230,21,231,21],[224,23,225,23],[214,21,215,21],[214,22,215,22],[200,18,201,18],[200,19,201,19],[200,20,201,20],[228,18,229,18],[208,19,209,19],[208,20,209,20],[208,21,209,21],[208,22,209,22],[210,19,211,19],[212,18,213,18],[212,19,213,19],[214,18,215,18],[214,19,215,19],[204,22,205,22],[208,18,209,18],[214,20,215,20],[204,21,205,21],[202,19,203,19],[202,18,203,18],[226,19,227,19],[216,20,217,20],[216,21,217,21],[246,19,247,19],[246,20,247,20],[246,21,247,21],[246,22,247,22],[230,23,231,23],[228,19,229,19],[234,19,235,19],[234,21,235,21],[246,23,247,23],[234,22,235,22],[234,20,235,20],[232,19,233,19],[232,20,233,20],[232,21,233,21],[232,22,233,22],[232,23,233,23],[230,22,231,22],[230,19,231,19],[214,24,215,24],[216,24,217,24],[234,24,235,24],[218,24,219,24],[220,24,221,24],[222,24,223,24],[224,24,225,24],[226,24,227,24],[228,24,229,24],[230,24,231,24],[232,24,233,24],[246,24,247,24],[236,18,237,18],[236,19,237,19],[236,20,237,20],[236,21,237,21],[236,22,237,22],[236,23,237,23],[240,18,241,18],[240,19,241,19],[240,20,241,20],[240,21,241,21],[240,22,241,22],[240,23,241,23],[236,24,237,24],[238,24,239,24],[240,24,241,24],[244,24,245,24],[246,18,247,18],[242,18,243,18],[242,19,243,19],[242,20,243,20],[242,21,243,21],[242,22,243,22],[242,23,243,23],[244,18,245,18],[244,19,245,19],[244,20,245,20],[244,21,245,21],[244,22,245,22],[244,23,245,23],[238,18,239,18],[238,19,239,19],[238,20,239,20],[238,21,239,21],[238,22,239,22],[482,19,482,20],[482,4,482,6],[482,1,482,3],[482,7,482,9],[482,10,482,12],[482,16,482,18],[482,13,482,15],[299,11,299,13],[410,1,421,1],[357,3,357,4],[359,3,359,4],[378,2,379,2],[370,3,370,4],[358,3,358,4],[360,3,360,4],[396,2,397,2],[382,10,382,11],[383,10,383,11],[384,10,384,11],[348,8,348,9],[353,3,353,4],[300,3,302,3],[350,3,350,4],[424,1,424,3],[244,17,245,17],[378,13,378,15],[232,12,233,12],[236,12,237,12],[234,16,235,16],[236,16,237,16],[369,8,369,9],[0,1,0,8],[396,3,397,3],[394,3,394,5],[393,1,393,6],[50,1,50,4],[136,1,136,2],[134,1,134,4],[293,1,293,8],[181,7,181,8],[182,7,182,8],[183,7,183,8],[184,7,184,8],[185,7,185,8],[186,7,186,8],[187,7,187,8],[188,7,188,8],[33,1,33,3],[471,1,471,3],[471,19,471,22],[220,18,221,18],[220,19,221,19],[222,16,223,16],[296,1,296,2],[396,8,397,8],[396,4,396,5],[224,2,225,2],[226,2,227,2],[226,21,227,21],[226,22,227,22],[240,9,251,9],[252,9,263,9],[232,2,233,2],[234,2,235,2],[236,2,237,2],[256,7,256,8],[257,7,257,8],[228,2,229,2],[230,2,231,2],[253,7,253,8],[254,7,254,8],[246,17,247,17]]}
[null,"BRIDGE PIER CAP 3"]
[null,"Analysis Input"]
[]
[null,"Bridge Details:"]
[null,"Bridge Name:","Bridge 3",null,"Pier Number:",null,"Pier-Line 2 (Left)",null,null,null,"Input Cell"]
[null,"SFN Number:","XXXXXXX",null,"Designer:",null,"XXXXXXXX",null,null,null,"Output Cell"]
[null,"PID No.:","XXXXXXX",null,"Date:",null,"XXXXXXXX"]
[null,null,null,null,null,null,null,null,"  "]
[null,"1. Total Number of Columns (Piers)",null,null,null,null,4,null,"Asymmetrical"]
[]
[]
[]
[]
[]
[null,"3. Geometry Details"]
[null,"Distance from start of the pier cap to center of first column (C1)",null,null,null,null,4,0,{"$f":"G16*12+H16","v":48}]
[null,"Distance from center of first column to center of second column (C2)",null,null,null,null,17,0,{"$f":"G17*12+H17","v":204}]
[null,"Distance from center of second column to centerline of pier cap (C3)",null,null,null,null,8,6,{"$f":"G18*12+H18","v":102}]
[null,"Distance from center of third column to centerline of pier cap (C4)",null,null,null,null,0,0,{"$f":"G19*12+H19","v":0}]
[null,"Distance from center of fourth column to centerline of pier cap (C5)",null,null,null,null,0,0,{"$f":"G20*12+H20","v":0}]
[null,"Column width (W)",null,null,null,null,36]
[null,"Depth of pier cap (h)",null,null,null,null,48.4]
[null,"Thickness of pier cap (t)",null,null,null,null,36]
[]
[null,null,null,null,"Distance from tip of cantilever to near edge of 1st column",{"$f":"I16-G21/2","v":30},"E in VBA\n<--",{"$f":"I16","v":48},"Running Centerline distance as calculated\n<--"]
[null,null,null,null,"Distance from tip of cantilever to near edge of 2nd column",{"$f":"F25+I17","v":234},null,{"$f":"H25+I17","v":252}]
[null,null,null,null,"Distance from tip of cantilever to near edge of 3rd column",{"$f":"F26+I18","v":336},null,{"$f":"H26+I18","v":354}]
[null,null,null,null,"Distance from tip of cantilever to near edge of 4th column",{"$f":"F27+I19","v":336},null,{"$f":"H27+I19","v":354}]
[null,null,null,null,"Approx. Effective depth of Pier-Cap (d=0.9*h)",{"$f":"0.9*G22","v":43.56},null,{"$f":"H28+I20","v":354}]
[]
[null,"4. Factored Loads and their Position",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ,"]
[null,"Distance of First Load from the Edge of Pier Cap",null,null,1,10.375,{"$f":"E32*12+F32","v":22.375}]
[null,"Spacing Between the Girders",null,null,13,8,{"$f":"E33*12+F33","v":164}]
[null,"Factored Load",null,null,400]
[]
[null,"Factored Load",null,"Distance"]
[null,"P1",400,1,10.375,{"$f":"ROUND(12*D37+E37,1)","v":22.4},"A1"]
[null,"P2",0,0,0,0,"A2"]
[null,"P3",400,13,8,164,"A3"]
[null,"P4",0,0,0,0,"A4"]
[null,"P5",0,0,0,0,"A5"]
[null,"P6",400,13,8,164,"A6"]
[null,"P7",0,0,0,0,"A7"]
[null,"P8",0,0,0,0,"A8"]
[null,"P9",0,0,0,0,"A9"]
[null,"P10",0,0,0,0,"A10"]
[null,"P11",0,0,0,0,"A11"]
[null,"P12",0,0,0,{"$f":"12*D48+E48","v":0},"A12"]
[]
[]
[null,"Distance of Load from the edge of the pier cap",null,null,null,"Distance from the edge of the pier cap to the reaction centerline\n"]
[null,"D1",{"$f":"F37","v":22.4},"D7",{"$f":"C57+F43","v":350.4},"Edge B1",{"$f":"F25+C301/2","v":43.620178041543028},"Edge B7",{"$f":"IF(C307=0,G57,F27+C307/2)","v":259.27570093457945}]
[null,"D2",{"$f":"C52+F38","v":22.4},"D8",{"$f":"E52+F44","v":350.4},"Edge B2",{"$f":"IF(C302=0,G52,F25+C301+C302/2)","v":43.620178041543028},"Edge B8",{"$f":"IF(G9=5,IF(C308=0,I52,F27+C307+C308),IF(C308=0,I52,F27+C307+C308/2))","v":259.27570093457945}]
[null,"D3",{"$f":"C53+F39","v":186.4},"D9",{"$f":"E53+F45","v":350.4},"Edge B3",{"$f":"IF(C303=0,G53,F25+C301+C302+C303/2)","v":61.620178041543028},"Edge B9",{"$f":"IF(C309=0,I53,F27+C307+C308+C309/2)","v":259.27570093457945}]
[null,"D4",{"$f":"C54+F40","v":186.4},"D10",{"$f":"E54+F46","v":350.4},"Edge B4",{"$f":"IF(C304=0,G54,F26+C304/2)","v":241.27570093457945},"Edge B10",{"$f":"IF(C310=0,I54,F28+C310/2)","v":259.27570093457945}]
[null,"D5",{"$f":"C55+F41","v":186.4},"D11",{"$f":"E55+F47","v":350.4},"Edge B5",{"$f":"IF(G9=3,IF(C305=0,G55,F26+C304+C305),IF(C305=0,G55,F26+C304+C305/2))","v":241.27570093457945},"Edge B11",{"$f":"IF(G9=7,IF(C311=0,I55,F28+C310+C311),IF(C311=0,I55,F28+C310+C311/2))","v":259.27570093457945}]
[null,"D6",{"$f":"C56+F42","v":350.4},"D12",{"$f":"E56+F48","v":350.4},"Edge B6",{"$f":"IF(C306=0,G56,F26+C304+C305+C306/2)","v":259.27570093457945},"Edge B12",{"$f":"IF(C312=0,I56,F28+C310+C311+C312/2)","v":259.27570093457945}]
[]
[null,null,null,null,null,null,null,null," "]
[null,"6. Check whether the Pier Cap is Deep",null,null,null,{"$f":"IF((SUM(D63:D74)/COUNTIF(D63:D74,\"<>0\"))>2, \"This pier cap is slender. \", \"This pier cap is deep.\n Please continue with Section 7.\")","v":"This pier cap is deep.\n Please continue with Section 7."}]
[]
[null,"Region","Shear span (a)","a/d ratio:","Result"]
[null,"R1",{"$f":"IF(F301=0,0,ABS(C52-(F25+C301/2)))","v":21.220178041543029},{"$f":"C63/F29","v":0.48714825623377017},{"$f":"IF(D63=0,\"Zero Region\",IF(D63<=2,\"Deep Region\",\"Slender Region\"))","v":"Deep Region"}]
[null,"R2",{"$f":"IF(F302=0,0,ABS(C53-(F25+C301+C302/2)))","v":0},{"$f":"ABS(C64/F29)","v":0},{"$f":"IF(D64=0,\"Zero Region\",IF(D64<=2,\"Deep Region\",\"Slender Region\"))","v":"Zero Region"}]
[null,"R3",{"$f":"IF(F303=0,0,IF(AND(C39>0,C40>0),ABS(C54-(F25+G21-C303/2)),ABS(C55-(F25+G21-C303/2))))","v":124.77982195845698},{"$f":"C65/F29","v":2.8645505500104904},"Slender Region"]
[null,"R4",{"$f":"IF(F304=0,0,ABS(C55-(F26+C304/2)))","v":54.875700934579442},{"$f":"C66/F29","v":1.259772748727719},"Deep Region"]
[null,"R5",{"$f":"IF(F305=0,0,ABS(C56-(F26+C304+C305/2)))","v":0},{"$f":"C67/F29","v":0},"Zero Region"]
[null,"R6",{"$f":"IF(F306=0,0,IF(AND(C42>0,C43>0),ABS(C57-(F26+G21-C306/2)),ABS(E52-(F26+G21-C306/2))))","v":91.12429906542053},{"$f":"C68/F29","v":2.0919260575165408},"Slender Region"]
[null,"R7",{"$f":"IF(F307=0,0,ABS(E52-(F27+C307/2)))","v":0},{"$f":"C69/F29","v":0},"Zero Region"]
[null,"R8",{"$f":"IF(F308=0,0,ABS(E53-(F27+C307+C308/2)))","v":0},{"$f":"C70/F29","v":0},"Zero Region"]
[null,"R9",{"$f":"IF(F309=0,0,IF(AND(C45>0,C46>0),ABS(E54-(F27+G23-C309/2)),ABS(E55-(F27+G23-C309/2))))","v":0},{"$f":"C71/F29","v":0},"Zero Region"]
[null,"R10",{"$f":"IF(F310=0,0,ABS(E55-(F28+C310/2)))","v":0},{"$f":"C72/F29","v":0},"Zero Region"]
[null,"R11",{"$f":"IF(F311=0,0,ABS(E56-(F28+C310+C311/2)))","v":0},{"$f":"C73/F29","v":0},"Zero Region"]
[null,"R12",{"$f":"IF(F312=0,0,ABS(E57-(F28+G23-C312/2)))","v":0},{"$f":"C74/F29","v":0},"Zero Region"]
[]
[]
[null,"7. Material Properties",null,null,null,"8. Resistance Factors Used"]
[null,"Concrete strength (f'c)",null,4,null,"For concrete",null,null,0.7]
[null,"Rebar yield strength (fy)",null,60,null,"For longitudinal rebar",null,null,0.9]
[null,"Enter the clear cover ",null,2,null,"For stirrup",null,null,0.9]
[null,"Stirrup yield strength(fy)",null,60,null,"CCC v-factor for the bearing and back face",null,null,0.85]
[null," Stirrup bar area",null,0.31,null,"CCT v-factor for the bearing and back face",null,null,0.7]
[null,null,null,null,null,"CTT v-factor for the bearing and back face",null,null,{"$f":"MAX(MIN(0.85-D78/20, 0.65), 0.45)","v":0.64999999999999991}]
[]
[]
[null,"9. Reinforcement Details"]
[]
[null,"9A. Longitudinal Reinforcement",null,null,null,null,"Rebar Area & Centroid'!A1"]
[null,"Region","Top Steel (in2, in)",null,"Bottom Steel (in2, in)"]
[null,null,"Total Area (At)","Centroid (Ct)","Total Area (Ab)","Centroid (Cb)"]
[null,"R1",12,5,12,5]
[null,"R2",12,5,12,5]
[null,"R3",12,5,12,5]
[null,"R4",12,5,12,5]
[null,"R5",12,5,12,5]
[null,"R6",12,5,12,5]
[null,"R7",0,0,0,0]
[null,"R8",0,0,0,0]
[null,"R9",0,0,0,0]
[null,"R10",0,0,0,0]
[null,"R11",0,0,0,0]
[null,"R12",0,0,0,0]
[]
[]
[null,"9B. Transverse Reinforcement",null,null,null,"9C. Min Horizontal Crack Control Reinforcement"]
[null,"Region","No. of Legs","Stirrup Spacing",null,"Crack control rebar area (in2)",null,null,0.44]
[null,"R1",4,9,null,"Spacing (in)",null,null,11]
[null,"R2",4,9,null,"No of layers of crack control rebar",null,null,2]
[null,"R3",4,9,null,"Provided crack control reinforcement ",null,null,{"$f":"IF(I107=0,\"-\",I106*I108/(I107*$G$23))","v":2.2222222222222222E-3}]
[null,"R4",4,9,null,"Code required crack control reinforcement",null,null,3.0000000000000001E-3]
[null,"R5",4,9]
[null,"R6",4,9]
[null,"R7",0,0]
[null,"R8",0,0]
[null,"R9",0,0]
[null,"R10",0,0]
[null,"R11",0,0]
[null,"R12",0,0]
[]
[]
[null,"10. Base Plate Dimensions"]
[null,"Base plate (bearing plate) length parallel to the pier cap (Lb)",null,null,null,16]
[null,"Base plate (bearing plate) width perpendicular to the pier cap (Wb)",null,null,null,21,null,null,null,null,null,null,null,null,null," "]
[]
[]
[null,"11. Reinforcement Development"]
[]
[null,"Horizontal length available (Ld)",null,null,{"$f":"IF(C37=0,IF(C38=0,C54+F122/2-D80-D93/(TAN(J303)),C53+F122/2-D80-D92/(TAN(J302))),C52+F122/2-D80-D91/(TAN(J301)))","v":29.781522007912955}]
[]
[null,"Top Tension Bars"]
[null,"Enter the diameter of the top longitudinal bar:",null,null,1.1279999999999999]
[null,"Enter the length of the hook provided:",null,null,32,{"$f":"IF(E132>=12*E131,\" It qualifies for 90° hook.\", \"It does not qualify for hook. Therefore, it will be considered as straight bar.\")","v":" It qualifies for 90° hook."}]
[null,"Basic development length",null,null,{"$f":"IF(E132<12*E131,2.4*E131*(D79)/SQRT(D78),38*(E131)/SQRT(D78)*(D79/60))","v":21.431999999999999}]
[]
[null,"Modification Factor"]
[null,"1. Are bars epoxy coated?",null,"Yes",{"$f":"IF(D136=\"Yes\",1.2,1)","v":1.2}]
[null,{"$f":"IF(E132>=12*E131,\"2. Is the side cover for No. 11 bar and smaller, normal to the plane of hook, is not less than 2.5 in, and 90° hook, cover on bar extension beyond hook not less than 2.0 in?\",\"2. For above epoxy-coated bars, Is the cover less than 3 times diameter of rebar or clear spacing between bars less than 6 times diameter of rebar?\")","v":"2. Is the side cover for No. 11 bar and smaller, normal to the plane of hook, is not less than 2.5 in, and 90° hook, cover on bar extension beyond hook not less than 2.0 in?"},null,"Yes",{"$f":"IF(E132>=12*E131,IF(D137=\"Yes\",0.7,1),IF(D137=\"Yes\",1.25,1))","v":0.7}]
[]
[null,"Required development length",null,null,{"$f":"E133*E136*E137","v":18.002879999999998}]
[null,"Available development length (Ld)",null,null,{"$f":"E128","v":29.781522007912955}]
[]
[null,"Horizontal length available",null,null,{"$f":"IF(C37=0,IF(C38=0,G54+C303/2-D80-F93/(TAN(J303)),G53+C302/2-D80-F92/(TAN(J302))),G52+C301/2-D80-F91/(TAN(J301)))","v":56.621878090999012}]
[]
[null,"Bottom Tension Bars"]
[null,"Enter the Diameter of the Bottom longitudinal bar:",null,null,0]
[null,"Enter the Length of the hook Provided:",null,null,0,{"$f":"IF(E146>=12*E145,\" It qualifies for 90° hook.\", \"It does not qualify for hook. Therefore, it will be considered as straight bar.\")","v":" It qualifies for 90° hook."}]
[null,"Basic Development Length ",null,null,{"$f":"IF(E146<12*E145,2.4*E145*(D79)/SQRT(D78),38*(E145)/SQRT(D78)*(D79/60))","v":0}]
[]
[null,"Modification Factor"]
[null,"1. Are those bars epoxy coated?",null,"No",{"$f":"IF(D150=\"Yes\",1.2,1)","v":1}]
[null,{"$f":"IF(E146>=12*E145,\"2. Is the side cover for No. 11 Bar and smaller, normal to the plane of hook, is not less than 2.5 in, and 90° hook, cover on bar extension beyond hook not less than 2.0 in?\",\"2. For above epoxy-coated bars, Is the cover less than 3 times diameter of rebar or clear spacing between bars less than 6 times diameter of rebar\")","v":"2. Is the side cover for No. 11 Bar and smaller, normal to the plane of hook, is not less than 2.5 in, and 90° hook, cover on bar extension beyond hook not less than 2.0 in?"},null,"No",{"$f":"IF(E146>=12*E145,IF(D151=\"Yes\",0.7,1),IF(D151=\"Yes\",1.25,1))","v":1}]
[]
[null,"Required development length",null,null,{"$f":"E147*E150*E151","v":0}]
[null,"Available development length (Ld)",null,null,{"$f":"E142","v":56.621878090999012}]
[]
[null,"Reinforcement Capacity Multiplier:",null,null,{"$f":"IF(Appendix!D19<20,MIN(Analysis!E140/Analysis!E139, 1), MIN(E154/E153,1))","v":1}]
[]
[]
[null,"Analysis Output"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[null,"13. Strut and Tie Output Summary"]
[]
[null,"STM Members",null,"Summary"]
[null,null,null,"Member Code","Force (k)","Capacity (k)","Utilization Ratio","Result"]
[null,null,null,"A-E",221.0435212660731,{"$f":"IF(Appendix!$D$19=11,G399*Analysis!$E$156,G399)","v":453.59999999999997},{"$f":"IF(F181=0,0,E181/F181)","v":0.48730935023384725},{"$f":"IF(OR(E181=0,F181=0),\"-\",IF(E181>=0,IF(ABS(E181)<ABS(F181),\"PASS\",\"Flexure Overloaded\"),IF(ABS(E181)<ABS(F181),\"PASS\",\"Compression Overloaded\")))","v":"PASS"},null,"Top Members "]
[null,null,null,"C-E",0,{"$f":"IF(Appendix!$D$19=12,G400*Analysis!$E$156,G400)","v":453.59999999999997},{"$f":"IF(AND(ABS(H29-E57)<0.01*H29,G9=1),\"-\",IF(F182=0,0,E182/F182))","v":0},"-"]
[null,null,null,"E-K",297.4911319967365,{"$f":"IF(Appendix!$D$19=13,G401*Analysis!$E$156,G401)","v":453.59999999999997},{"$f":"IF(F183=0,0,E183/F183)","v":0.65584464725911928},"PASS"]
[null,null,null,"E-K",297.4911319967365,{"$f":"G402","v":453.59999999999997},0.65584464725911928,"PASS"]
[null,null,null,"I-K",0,{"$f":"G403","v":453.59999999999997},{"$f":"IF(AND(ABS(H29-E57)<0.01*H29,G9=3),\"-\",IF(F185=0,0,E185/F185))","v":0},"-"]
[null,null,null,"K-Q",297.49113199673582,453.59999999999997,0.65584464725911784,{"$f":"IF(OR(E186=0,F186=0),\"-\",IF(E186>=0,IF(ABS(E186)<ABS(F186),\"PASS\",\"Flexure Overloaded\"),IF(ABS(E186)<ABS(F186),\"PASS\",\"Compression Overloaded\")))","v":"PASS"}]
[null,null,null,"K-Q",297.49113199673582,0,0,{"$f":"IF(OR(E187=0,F187=0),\"-\",IF(E187>=0,IF(ABS(E187)<ABS(F187),\"PASS\",\"Flexure Overloaded\"),IF(ABS(E187)<ABS(F187),\"PASS\",\"Compression Overloaded\")))","v":"-"}]
[null,null,null,"O-Q",0,0,{"$f":"IF(AND(ABS(H29-E57)<0.01*H29,G9=5),\"-\",IF(F188=0,0,E188/F188))","v":0},"-"]
[null,null,null,"Q-W",221.04352126607151,0,0,"-"]
[null,null,null,"Q-W",221.04352126607151,0,0,"-"]
[null,null,null,"U-W",0,0,{"$f":"IF(AND(ABS(H29-E57)<0.01*H29,G9=7),\"-\",IF(F191=0,0,E191/F191))","v":0},"-"]
[null,null,null,"W+",0,0,0,{"$f":"IF(OR(E192=0,F192=0),\"-\",IF(E192>=0,IF(ABS(E192)<ABS(F192),\"PASS\",\"Flexure Overloaded\"),IF(ABS(E192)<ABS(F192),\"PASS\",\"Compression Overloaded\")))","v":"-"}]
[null,null,null,"2-6",-221.04352126607358,{"$f":"IF(Appendix!$D$19=21,G411*Analysis!$E$156,G411)","v":-1101.5999999999999},{"$f":"IF(F193=0,0,E193/F193)","v":0.20065679127276106},"PASS",null,"Bottom Members"]
[null,null,null,"4-6",0,{"$f":"IF(Appendix!$D$19=22,G412*Analysis!$E$156,G412)","v":453.59999999999997},0,"-"]
[null,null,null,"6-8",122.8799872000793,{"$f":"IF(Appendix!$D$19=23,G413*Analysis!$E$156,G413)","v":453.59999999999997},0.27089944268095084,"PASS"]
[null,null,null,"8-12",-297.49113199673707,{"$f":"G414","v":-1101.5999999999999},0.27005367828316729,"PASS"]
[null,null,null,"10-12",0,{"$f":"G415","v":453.59999999999997},0,"-"]
[null,null,null,"12-14",195.86459230232666,453.59999999999997,0.43180024758008523,"PASS"]
[null,null,null,"14-18",-297.49113199673673,-453.59999999999997,0.65584464725911984,"PASS"]
[null,null,null,"16-18",0,0,0,"-"]
[null,null,null,"18-20",122.87998720007985,0,0,"-"]
[null,null,null,"20-24",-221.04352126607125,-453.59999999999997,0.4873093502338432,"PASS"]
[null,null,null,"22-24",0,0,0,"-"]
[null,null,null,"24+",0,0,0,"-"]
[null,"Input 0 for \"Do not use Tie\"\nInput 1 for \"Use Tie\"     \nInput Your Option Down Here\n↓↓↓↓↓↓↓",null,"B-1",0,{"$f":"IF(C217=0,\"-\",C381)","v":"-"},{"$f":"IF(F205=0,0,IF(C217=0,0,E205/F205))","v":0},{"$f":"IF(OR(C217=0, F205=0),\"-\",IF(ABS(E205)<ABS(F205),\"PASS\",\"Shear Overloaded\"))","v":"-"},null,"Vertical Members"]
[null,null,null,"D-3",0,{"$f":"IF(C219=0,\"-\",C382)","v":"-"},{"$f":"IF(F206=0,0,IF(C219=0,0,E206/F206))","v":0},{"$f":"IF(OR(C219=0, F206=0),\"-\",IF(ABS(E206)<ABS(F206),\"PASS\",\"Shear Overloaded\"))","v":"-"}]
[null,null,null,"F-5",0,{"$f":"IF(C221=0,\"-\",C383)","v":"-"},{"$f":"IF(F207=0,0,IF(C221=0,0,E207/F207))","v":0},{"$f":"IF(OR(C221=0, F207=0),\"-\",IF(ABS(E207)<ABS(F207),\"PASS\",\"Shear Overloaded\"))","v":"-"}]
[null,null,null,"H-7",0,{"$f":"IF(C223=0,\"-\",C384)","v":"-"},{"$f":"IF(F208=0,0,IF(C223=0,0,E208/F208))","v":0},{"$f":"IF(OR(C223=0, F208=0),\"-\",IF(ABS(E208)<ABS(F208),\"PASS\",\"Shear Overloaded\"))","v":"-"}]
[null,null,null,"J-9",0,{"$f":"IF(C225=0,\"-\",C385)","v":"-"},{"$f":"IF(F209=0,0,IF(C225=0,0,E209/F209))","v":0},{"$f":"IF(OR(C225=0, F209=0),\"-\",IF(ABS(E209)<ABS(F209),\"PASS\",\"Shear Overloaded\"))","v":"-"}]
[null,null,null,"L-11",0,{"$f":"IF(C227=0,\"-\",C386)","v":"-"},{"$f":"IF(F210=0,0,IF(C227=0,0,E210/F210))","v":0},{"$f":"IF(OR(C227=0, F210=0),\"-\",IF(ABS(E210)<ABS(F210),\"PASS\",\"Shear Overloaded\"))","v":"-"}]
[null,null,null,"N-13",0,{"$f":"IF(C229=0,\"-\",C387)","v":"-"},{"$f":"IF(F211=0,0,IF(C229=0,0,E211/F211))","v":0},{"$f":"IF(OR(C229=0, F211=0),\"-\",IF(ABS(E211)<ABS(F211),\"PASS\",\"Shear Overloaded\"))","v":"-"}]
[null,null,null,"P-15",0,{"$f":"IF(C231=0,\"-\",C388)","v":"-"},{"$f":"IF(F212=0,0,IF(C231=0,0,E212/F212))","v":0},{"$f":"IF(OR(C231=0, F212=0),\"-\",IF(ABS(E212)<ABS(F212),\"PASS\",\"Shear Overloaded\"))","v":"-"}]
[null,null,null,"R-17",0,{"$f":"IF(C233=0,\"-\",C389)","v":"-"},{"$f":"IF(F213=0,0,IF(C233=0,0,E213/F213))","v":0},{"$f":"IF(OR(C233=0, F213=0),\"-\",IF(ABS(E213)<ABS(F213),\"PASS\",\"Shear Overloaded\"))","v":"-"}]
[null,null,null,"T-19",0,{"$f":"IF(C235=0,\"-\",C390)","v":"-"},{"$f":"IF(F214=0,0,IF(C235=0,0,E214/F214))","v":0},{"$f":"IF(OR(C235=0, F214=0),\"-\",IF(ABS(E214)<ABS(F214),\"PASS\",\"Shear Overloaded\"))","v":"-"}]
[null,null,null,"V-21",0,{"$f":"IF(C237=0,\"-\",C391)","v":"-"},{"$f":"IF(F215=0,0,IF(C237=0,0,E215/F215))","v":0},{"$f":"IF(OR(C237=0, F215=0),\"-\",IF(ABS(E215)<ABS(F215),\"PASS\",\"Shear Overloaded\"))","v":"-"}]
[null,null,null,"X-23",0,{"$f":"IF(C239=0,\"-\",C392)","v":"-"},{"$f":"IF(F216=0,0,IF(C239=0,0,E216/F216))","v":0},{"$f":"IF(OR(C239=0, F216=0),\"-\",IF(ABS(E216)<ABS(F216),\"PASS\",\"Shear Overloaded\"))","v":"-"}]
[null,null,0,"A-2",-457.01229556074861,{"$f":"IF(C217=0,G454,G430)","v":-854.61451483940277},{"$f":"IF(OR(F217=0,E217=0),0,E217/F217)","v":0.53475840583708001},{"$f":"IF(G217<=1,\"PASS\",IF(E217<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"},null,"Inclined Members"]
[null,null,null,"B-2",0,{"$f":"IF(C217=0,0,G431)","v":0},{"$f":"IF(OR(F218=0,E218=0),0,E218/F218)","v":0},{"$f":"IF(G218<=1,\"PASS\",IF(E218<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,0,"C-4",0,{"$f":"IF(C219=0,G455,G432)","v":0},0,{"$f":"IF(G219<=1,\"PASS\",IF(E219<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,null,"D-4",0,{"$f":"IF(C219=0,0,G433)","v":0},0,{"$f":"IF(G220<=1,\"PASS\",IF(E220<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,0,"E-6",-359.84083734784139,{"$f":"IF(C221=0,G456,G434)","v":-502.1796730887562},0.71655795053306037,"PASS"]
[null,null,null,"E-5",0,{"$f":"IF(C221=0,0,G435)","v":0},0,{"$f":"IF(G222<=1,\"PASS\",IF(E222<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,0,"E-8",-513.0712835663245,{"$f":"IF(C223=0,G457,G436)","v":-653.94127370329909},0.78458311808456216,"PASS"]
[null,null,null,"H-8",0,{"$f":"IF(C223=0,0,G437)","v":0},0,{"$f":"IF(G224<=1,\"PASS\",IF(E224<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,0,"I-10",0,{"$f":"IF(C225=0,G458,G438)","v":0},0,"PASS"]
[null,null,null,"J-10",0,{"$f":"IF(C225=0,0,G439)","v":0},0,{"$f":"IF(G226<=1,\"PASS\",IF(E226<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,0,"K-12",-532.35314472505331,{"$f":"IF(C227=0,G459,G440)","v":-699.83644147465031},0.76068222969828925,"PASS"]
[null,null,null,"K-11",0,{"$f":"IF(C227=0,0,G441)","v":0},0,{"$f":"IF(G228<=1,\"PASS\",IF(E228<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,0,"K-14",{"$f":"IF(C229=0,Appendix!J96,Appendix!J84)","v":0},{"$f":"IF(C229=0,G460,G442)","v":0},0,"PASS"]
[null,null,null,"N-14",{"$f":"IF(C229=0,0,Appendix!J84)","v":0},{"$f":"IF(C229=0,0,G443)","v":0},0,{"$f":"IF(G230<=1,\"PASS\",IF(E230<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,0,"O-16",{"$f":"IF(C231=0,Appendix!J97,Appendix!J85)","v":0},{"$f":"IF(C231=0,G461,G444)","v":0},0,"PASS"]
[null,null,null,"P-16",{"$f":"IF(C231=0,0,Appendix!J85)","v":0},{"$f":"IF(C231=0,0,G445)","v":0},0,{"$f":"IF(G232<=1,\"PASS\",IF(E232<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,0,"Q-18",{"$f":"IF(C233=0,Appendix!J98,Appendix!J86)","v":0},{"$f":"IF(C233=0,G462,G446)","v":0},0,"PASS"]
[null,null,null,"Q-17",{"$f":"IF(C233=0,0,Appendix!J86)","v":0},{"$f":"IF(C233=0,0,G447)","v":0},0,{"$f":"IF(G234<=1,\"PASS\",IF(E234<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,0,"Q-20",{"$f":"IF(C235=0,Appendix!J99,Appendix!J87)","v":0},{"$f":"IF(C235=0,G463, G448)","v":0},0,"PASS"]
[null,null,null,"T-20",{"$f":"IF(C235=0,0,Appendix!J87)","v":0},{"$f":"IF(C235=0,0,G449)","v":0},0,{"$f":"IF(G236<=1,\"PASS\",IF(E236<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,0,"U-22",{"$f":"IF(C237=0,Appendix!J100,Appendix!J88)","v":0},{"$f":"IF(C237=0,G464,G450)","v":0},0,"PASS"]
[null,null,null,"V-22",{"$f":"IF(C237=0,0,Appendix!J88)","v":0},{"$f":"IF(C237=0,0,G451)","v":0},0,{"$f":"IF(G238<=1,\"PASS\",IF(E238<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,0,"W-24",{"$f":"IF(C239=0,Appendix!J101,Appendix!J89)","v":0},{"$f":"IF(C239=0,G465,G452)","v":0},0,"PASS"]
[null,null,null,"W-23",{"$f":"IF(C239=0,0,Appendix!J89)","v":0},{"$f":"IF(C239=0,0,G453)","v":0},0,{"$f":"IF(G240<=1,\"PASS\",IF(E240<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,"Bearing Areas","Nodes at ⇉","A",{"$f":"C37","v":400},{"$f":"$I$78*D349*$F$123*$F$122*Appendix!$P$41","v":771.56457772502756},{"$f":"IF(F241=0,0,E241/F241)","v":0.51842711750636272},{"$f":"IF(G241<=1,\"PASS\",IF(E241<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"},null,1]
[null,null,null,"C",0,{"$f":"$I$78*D351*$F$123*$F$122*Appendix!$P$41","v":771.56457772502756},0,{"$f":"IF(G242<=1,\"PASS\",IF(E242<>0,\"Shear Overloaded\",\"-\"))","v":"PASS"}]
[null,null,null,"E",400,{"$f":"$I$78*D353*$F$123*$F$122*Appendix!$P$41","v":771.56457772502756},0.51842711750636272,"PASS"]
[null,null,null,"G",0,{"$f":"$I$78*D355*$F$123*$F$122*Appendix!$P$41","v":771.56457772502756},0,"PASS"]
[null,null,null,"I",0,{"$f":"$I$78*D357*$F$123*$F$122*Appendix!$P$41","v":771.56457772502756},0,"PASS"]
[null,null,null,"K",400,{"$f":"$I$78*D359*$F$123*$F$122*Appendix!$P$41","v":771.56457772502756},0.51842711750636272,"PASS"]
[null,null,null,"M",0,{"$f":"$I$78*D361*$F$123*$F$122*Appendix!$P$41","v":771.56457772502756},0,"PASS"]
[null,null,null,"O",0,{"$f":"$I$78*D363*$F$123*$F$122*Appendix!$P$41","v":771.56457772502756},0,"PASS"]
[null,null,null,"Q",0,{"$f":"$I$78*D365*$F$123*$F$122*Appendix!$P$41","v":771.56457772502756},0,"PASS"]
[null,null,null,"S",0,{"$f":"$I$78*D367*$F$123*$F$122*Appendix!$P$41","v":771.56457772502756},0,"PASS"]
[null,null,null,"U",0,{"$f":"$I$78*D369*$F$123*$F$122*Appendix!$P$41","v":771.56457772502756},0,"PASS"]
[null,null,null,"W",0,{"$f":"$I$78*D371*$F$123*$F$122*Appendix!$P$41","v":771.56457772502756},0,"PASS"]
[null,null,null,"2",{"$f":"Appendix!B79","v":400.00000000000017},{"$f":"IF(Appendix!$U$30=\"Circular\",$I$78*I349*Appendix!V78*G$21/1.273,$I$78*I349*Appendix!V78*$G$21)","v":1014.3648626010385},0.39433542578980757,"PASS",null,2]
[null,null,null,"4",{"$f":"Appendix!B80","v":0},{"$f":"IF(Appendix!$U$30=\"Circular\",$I$78*I351*Appendix!V79*G$21/1.273,$I$78*I351*Appendix!V79*$G$21)","v":0},0,"PASS"]
[null,null,null,"6",{"$f":"Appendix!B81","v":105.83973047739521},{"$f":"IF(Appendix!$U$30=\"Circular\",$I$78*I353*Appendix!V80*G$21/1.273,$I$78*I353*Appendix!V80*$G$21)","v":268.40025915858467},0.39433542578980763,"PASS"]
[null,null,null,"8",{"$f":"Appendix!B82","v":294.16026952260484},{"$f":"IF(Appendix!$U$30=\"Circular\",$I$78*I355*Appendix!V81*G$21/1.273,$I$78*I355*Appendix!V81*$G$21)","v":763.5954511590819},0.38523051581317191,"PASS"]
[null,null,null,"10",{"$f":"Appendix!B83","v":0},{"$f":"IF(Appendix!$U$30=\"Circular\",$I$78*I357*Appendix!V82*G$21/1.273,$I$78*I357*Appendix!V82*$G$21)","v":0},{"$f":"IF(F257=0,0,E257/F257)","v":0},"PASS"]
[null,null,null,"12",{"$f":"Appendix!B84","v":200.00000000000099},{"$f":"IF(Appendix!$U$30=\"Circular\",$I$78*I359*Appendix!V83*G$21/1.273,$I$78*I359*Appendix!V83*$G$21)","v":519.16967060054117},0.38523051581317186,"PASS"]
[null,null,null,"14",{"$f":"Appendix!B85","v":0},{"$f":"IF(Appendix!$U$30=\"Circular\",$I$78*I361*Appendix!V84*G$21/1.273,$I$78*I361*Appendix!V84*$G$21)","v":0},0,"PASS"]
[null,null,null,"16",{"$f":"Appendix!B86","v":0},{"$f":"IF(Appendix!$U$30=\"Circular\",$I$78*I363*Appendix!V85*G$21/1.273,$I$78*I363*Appendix!V85*$G$21)","v":0},0,"PASS"]
[null,null,null,"18",{"$f":"Appendix!B87","v":0},{"$f":"IF(Appendix!$U$30=\"Circular\",$I$78*I365*Appendix!V86*G$21/1.273,$I$78*I365*Appendix!V86*$G$21)","v":0},0,"PASS"]
[null,null,null,"20",{"$f":"Appendix!B88","v":0},{"$f":"IF(Appendix!$U$30=\"Circular\",$I$78*I367*Appendix!V87*G$21/1.273,$I$78*I367*Appendix!V87*$G$21)","v":0},0,"PASS"]
[null,null,null,"22",{"$f":"Appendix!B89","v":0},{"$f":"IF(Appendix!$U$30=\"Circular\",$I$78*I369*Appendix!V88*G$21/1.273,$I$78*I369*Appendix!V88*$G$21)","v":0},0,"PASS"]
[null,null,null,"24",{"$f":"Appendix!B90","v":0},{"$f":"IF(Appendix!$U$30=\"Circular\",$I$78*I371*Appendix!V89*G$21/1.273,$I$78*I371*Appendix!V89*$G$21)","v":0},0,"PASS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Calculation Details"]
[]
[]
[null,"Top tie width:",null,10]
[null,"Bottom strut width:",null,10]
[null,"Approximate Reactions (See section 17 for exact reactions)"]
[null,"Support Division",null,"Approximate Reaction Forces",null,null,null,null,"If Vertical Ties Used",null,null,"If Vertical Ties not Used"]
[null,"B1",{"$f":"IF(AND(F301=0,F302=0,F303=0),0,F301/(F301+F302+F303)*G21)","v":27.240356083086056},"First Support Proportioning/ Reaction","F2",{"$f":"C37","v":400},null,"Angle with top Horizontal Member","θA  (=θB)",{"$f":"IF(C37=0,0,ATAN((G22-D297/2-D298/2)/(0.5*(C52-(F25+C301/2)))))","v":-1.3012178290012415},{"$f":"J301*180/PI()","v":-74.554289828946793},"θA ",{"$f":"IF(C37=0,0,ATAN((G22-D297/2-D298/2)/((C52-(F25+C301/2)))))","v":-1.0659524026405884},{"$f":"DEGREES(M301)","v":-61.074573833135503}]
[null,"B2",{"$f":"IF(AND(F301=0,F302=0,F303=0),0,F302/(F301+F302+F303)*G21)","v":0},null,"F4",{"$f":"C38","v":0},null,null,"θC  (=θD)",{"$f":"ATAN((G22-D297/2-D298/2)/(0.5*(C53-(F25+C301+C302/2))))","v":-1.1449108175995832},{"$f":"DEGREES(J302)","v":-65.598557767328529},"θC ",{"$f":"ATAN((G22-D297/2-D298/2)/((C53-(F25+C301+C302/2))))","v":-0.83396216879006946},-47.782512545247762]
[null,"B3",{"$f":"IF(AND(F301=0,F302=0,F303=0),0,F303/(F301+F302+F303)*G21)","v":8.7596439169139444},null,"F6",{"$f":"IF(Appendix!N25=FALSE,IF(G9=2,C39,IF(OR(C39>0,C40>0),(C39*(H26-C54)+C40*(H26-C55))/I17,0)), IF(G9=1,C39,IF(OR(C39>0,C40>0),(C39*(H26-C54)+C40*(H26-C55))/I17,0)))","v":128.62745098039213},null,null,"θE  (=θF)",{"$f":"ATAN((G22-D297/2-D298/2)/(0.5*(C54-(F25+G21-C303/2))))","v":0.55172715852321641},31.611637626125624,"θE ",{"$f":"ATAN((G22-D297/2-D298/2)/((C54-(F25+G21-C303/2))))","v":0.29854438433901398},17.105333219957053]
[null,"B4",{"$f":"IF(AND(F304=0,F305=0,F306=0),0,IF(G9=3,F304/(F304+F305)*(G21/2),F304/(F304+F305+F306)*G21))","v":14.551401869158878},"Second Support Proportioning/ Reaction","F8",{"$f":"IF(Appendix!N25=FALSE,IF(G9=2,0,IF(OR(C39>0,C40>0),(C39*(C54-H25)+C40*(C55-H25))/I17,0)), IF(G9=1,0,IF(OR(C39>0,C40>0),(C39*(C54-H25)+C40*(C55-H25))/I17,0)))","v":271.37254901960785},null,null,"θG  (=θH)",{"$f":"ATAN((G22-D297/2-D298/2)/(0.5*(C55-(F26+C304/2))))","v":-0.95038685315205695},-54.4531555903324,"θG ",{"$f":"ATAN((G22-D297/2-D298/2)/((C55-(F26+C304/2))))","v":-0.61056706838626595},-34.982916128208551]
[null,"B5",{"$f":"IF(AND(F304=0,F305=0,F306=0),0,IF(G9=3,F305/(F304+F305)*(G21/2),F305/(F304+F305+F306)*G21))","v":0},null,"F10",{"$f":"IF(AND(ABS(H29-E57)<0.01*H29, G9=3),C41/2,C41)","v":0},null,null,"θI  (=θJ)",{"$f":"ATAN((G22-D297/2-D298/2)/(0.5*(C56-(F26+C304+C305/2))))","v":-0.89043265246371162},-51.01803292680988,"θI",{"$f":"ATAN((G22-D297/2-D298/2)/((C56-(F26+C304+C305/2))))","v":-0.55343837528934936},-31.709683124657069]
[null,"B6",{"$f":"IF(AND(F304=0,F305=0,F306=0),0,F306/(F304+F305+F306)*G21)","v":21.448598130841123},null,"F12",{"$f":"IF(Appendix!N25=FALSE,IF(G9=4,C42,IF(OR(C42>0,C43>0),(C42*(H27-C57)+C43*(H27-E52))/I18,0)), IF(G9=2,C42,IF(OR(C42>0,C43>0),(C42*(H27-C57)+C43*(H27-E52))/I18,0)))","v":400},null,null,"θK  (=θL)",{"$f":"ATAN((G22-D297/2-D298/2)/(0.5*(C57-(F26+G21-C306/2))))","v":0.7003020415874367},40.124351367355182,"θK ",{"$f":"ATAN((G22-D297/2-D298/2)/((C57-(F26+G21-C306/2))))","v":0.39881952152343014},22.850675370719443]
[null,"B7",{"$f":"IF(AND(F307=0,F308=0,F309=0),0,IF(G9=5,F307/(F307+F308)*(G21/2),F307/(F307+F308+F309)*G21))","v":0},"Third Support Proportioning/ Reaction","F14",{"$f":"IF(Appendix!N25=FALSE,IF(G9=4,0,IF(OR(C42>0,C43>0),(C42*(C57-H26)+C43*(E52-H26))/I18,0)), IF(G9=2,0,IF(OR(C42>0,C43>0),(C42*(C57-H26)+C43*(E52-H26))/I18,0)))","v":0},null,null,"θM  (=θN)",{"$f":"ATAN((G22-D297/2-D298/2)/(0.5*(E52-(F27+C307/2))))","v":1.3854483767992021},79.380344723844885,"θM  ",{"$f":"ATAN((G22-D297/2-D298/2)/((E52-(F27+C307/2))))","v":1.212025656524325},69.443954780416576]
[null,"B8",{"$f":"IF(AND(F307=0,F308=0,F309=0),0,IF(G9=5,F308/(F307+F308)*(G21/2),F308/(F307+F308+F309)*G21))","v":0},null,"F16",{"$f":"IF(AND(ABS(H29-E57)<0.01*H29, G9=5),C44/2,C44)","v":0},null,null,"θO  (=θP)",{"$f":"ATAN((G22-D297/2-D298/2)/(0.5*(E53-(F27+C307+C308/2))))","v":1.3854483767992021},79.380344723844885,"θO ",{"$f":"ATAN((G22-D297/2-D298/2)/((E53-(F27+C307+C308/2))))","v":1.212025656524325},69.443954780416576]
[null,"B9",{"$f":"IF(AND(F307=0,F308=0,F309=0),0,F309/(F307+F308+F309)*G21)","v":0},null,"F18",{"$f":"IF(Appendix!N25=FALSE,IF(G9=6,C45,IF(OR(C45>0,C46>0),(C45*(H28-E54)+C46*(H28-E55))/I19,0)), IF(G9=3,C45,IF(OR(C45>0,C46>0),(C45*(H28-E54)+C46*(H28-E55))/I19,0)))","v":0},null,null,"θQ  (=θR)",{"$f":"ATAN((G22-D297/2-D298/2)/(0.5*(E54-(F27+G21-C309/2))))","v":-1.2966288756752375},-74.291362170984243,"θQ ",{"$f":"ATAN((G22-D297/2-D298/2)/((E54-(F27+G21-C309/2))))","v":-1.0584068664841584},-60.642246457208699]
[null,"B10",{"$f":"IF(AND(F310=0,F311=0,F312=0),0,IF(G9=7,F310/(F310+F311)*(G21/2),F310/(F310+F311+F312)*G21))","v":0},"Fourth Support Proportioning/ Reaction","F20",{"$f":"IF(Appendix!N25=FALSE,IF(G9=6,0,IF(OR(C45>0,C46>0),(C45*(E54-H27)+C46*(E55-H27))/I19,0)),IF(G9=3,0,IF(OR(C45>0,C46>0),(C45*(E54-H27)+C46*(E55-H27))/I19,0)))","v":0},null,null,"θS  (=θT)",{"$f":"ATAN((G22-D297/2-D298/2)/(0.5*(E55-(F28+C310/2))))","v":1.3854483767992021},79.380344723844885,"θS  ",{"$f":"ATAN((G22-D297/2-D298/2)/((E55-(F28+C310/2))))","v":1.212025656524325},69.443954780416576]
[null,"B11",{"$f":"IF(AND(F310=0,F311=0,F312=0),0,IF(G9=5,F311/(F310+F311)*(G21/2),F311/(F310+F311+F312)*G21))","v":0},null,"F22",{"$f":"IF(AND(ABS(H29-E57)<0.01*H29,G9=7),C47/2,C47)","v":0},null,null,"θU  (=θV)",{"$f":"ATAN((G22-D297/2-D298/2)/(0.5*(E56-(F28+C310+C311/2))))","v":1.3854483767992021},79.380344723844885,"θU ",{"$f":"ATAN((G22-D297/2-D298/2)/((E56-(F28+C310+C311/2))))","v":1.212025656524325},69.443954780416576]
[null,"B12",{"$f":"IF(AND(F310=0,F311=0,F312=0),0,F312/(F310+F311+F312)*G21)","v":0},null,"F24",{"$f":"C48","v":0},null,null,"θW  (=θX)",{"$f":"ATAN((G22-D297/2-D298/2)/(0.5*(E57-(F28+G21-C312/2))))","v":-1.2966288756752375},-74.291362170984243,"θW ",{"$f":"ATAN((G22-D297/2-D298/2)/((E57-(F28+G21-C312/2))))","v":-1.0584068664841584},-60.642246457208699]
[]
[]
[null,"14. Nodal Compressive Strength"]
[]
[]
[null,"Number of Tension Forces At Each Nodes"]
[]
[null,"Top Nodes","Force 1","Force 2","Force 3","Force 4","No. of Tension","Bottom Nodes","Force 1","Force 2","Force 3","Force 4","No. of Tension"]
[null,"A",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B321,ROW($T$485:$U$955)-484),1)),\"\")","v":221.0435212660731},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B321,ROW($T$485:$U$955)-484),2)),\"\")","v":-457.01229556074861},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B321,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B321,ROW($T$485:$U$955)-484),4)),\"\")","v":""},{"$f":"COUNTIF(C321:F321,\">0\")","v":1},1,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"1\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"1\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"1\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"1\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},{"$f":"COUNTIF(I321:L321,\">0\")","v":0}]
[null,"B",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B322,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B322,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B322,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B322,ROW($T$485:$U$955)-484),4)),\"\")","v":""},{"$f":"COUNTIF(C322:F322,\">0\")","v":0},2,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"2\",ROW($T$485:$U$955)-484),1)),\"\")","v":-221.04352126607358},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"2\",ROW($T$485:$U$955)-484),2)),\"\")","v":-457.01229556074861},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"2\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"2\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},{"$f":"COUNTIF(I322:L322,\">0\")","v":0}]
[null,"C",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B323,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B323,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B323,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B323,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,3,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"3\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"3\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"3\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"3\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"D",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B324,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B324,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B324,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B324,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,4,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"4\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"4\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"4\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"4\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"E",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B325,ROW($T$485:$U$955)-484),1)),\"\")","v":221.0435212660731},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B325,ROW($T$485:$U$955)-484),2)),\"\")","v":297.4911319967365},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B325,ROW($T$485:$U$955)-484),3)),\"\")","v":-359.84083734784139},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B325,ROW($T$485:$U$955)-484),4)),\"\")","v":-513.0712835663245},2,5,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"5\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"5\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"5\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"5\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"F",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B326,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B326,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B326,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B326,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,6,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"6\",ROW($T$485:$U$955)-484),1)),\"\")","v":-221.04352126607358},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"6\",ROW($T$485:$U$955)-484),2)),\"\")","v":122.8799872000793},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"6\",ROW($T$485:$U$955)-484),3)),\"\")","v":-359.84083734784139},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"6\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},1]
[null,"G",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B327,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B327,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B327,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B327,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,7,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"7\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"7\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"7\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"7\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"H",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B328,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B328,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B328,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B328,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,8,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"8\",ROW($T$485:$U$955)-484),1)),\"\")","v":122.8799872000793},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"8\",ROW($T$485:$U$955)-484),2)),\"\")","v":-297.49113199673707},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"8\",ROW($T$485:$U$955)-484),3)),\"\")","v":-513.0712835663245},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"8\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},1]
[null,"I",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B329,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B329,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B329,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B329,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,9,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"9\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"9\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"9\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"9\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"J",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B330,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B330,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B330,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B330,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,10,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"10\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"10\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"10\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"10\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"K",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B331,ROW($T$485:$U$955)-484),1)),\"\")","v":297.4911319967365},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B331,ROW($T$485:$U$955)-484),2)),\"\")","v":297.49113199673582},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B331,ROW($T$485:$U$955)-484),3)),\"\")","v":-532.35314472505331},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B331,ROW($T$485:$U$955)-484),4)),\"\")","v":-532.35314472505195},2,11,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"11\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"11\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"11\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"11\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"L",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B332,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B332,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B332,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B332,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,12,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"12\",ROW($T$485:$U$955)-484),1)),\"\")","v":-297.49113199673707},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"12\",ROW($T$485:$U$955)-484),2)),\"\")","v":195.86459230232666},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"12\",ROW($T$485:$U$955)-484),3)),\"\")","v":-532.35314472505331},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"12\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},1]
[null,"M",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B333,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B333,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B333,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B333,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,13,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"13\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"13\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"13\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"13\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"N",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B334,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B334,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B334,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B334,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,14,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"14\",ROW($T$485:$U$955)-484),1)),\"\")","v":195.86459230232666},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"14\",ROW($T$485:$U$955)-484),2)),\"\")","v":-297.49113199673673},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"14\",ROW($T$485:$U$955)-484),3)),\"\")","v":-532.35314472505195},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"14\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},1]
[null,"O",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B335,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B335,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B335,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B335,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,15,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"15\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"15\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"15\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"15\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"P",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B336,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B336,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B336,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B336,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,16,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"16\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"16\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"16\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"16\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"Q",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B337,ROW($T$485:$U$955)-484),1)),\"\")","v":297.49113199673582},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B337,ROW($T$485:$U$955)-484),2)),\"\")","v":221.04352126607151},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B337,ROW($T$485:$U$955)-484),3)),\"\")","v":-513.07128356632506},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B337,ROW($T$485:$U$955)-484),4)),\"\")","v":-359.84083734783997},2,17,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"17\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"17\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"17\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"17\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"R",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B338,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B338,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B338,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B338,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,18,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"18\",ROW($T$485:$U$955)-484),1)),\"\")","v":-297.49113199673673},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"18\",ROW($T$485:$U$955)-484),2)),\"\")","v":122.87998720007985},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"18\",ROW($T$485:$U$955)-484),3)),\"\")","v":-513.07128356632506},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"18\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},1]
[null,"S",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B339,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B339,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B339,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B339,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,19,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"19\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"19\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"19\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"19\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"T",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B340,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B340,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B340,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B340,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,20,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"20\",ROW($T$485:$U$955)-484),1)),\"\")","v":122.87998720007985},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"20\",ROW($T$485:$U$955)-484),2)),\"\")","v":-221.04352126607125},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"20\",ROW($T$485:$U$955)-484),3)),\"\")","v":-359.84083734783997},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"20\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},1]
[null,"U",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B341,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B341,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B341,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B341,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,21,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"21\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"21\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"21\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"21\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"V",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B342,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B342,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B342,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B342,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,22,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"22\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"22\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"22\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"22\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"W",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B343,ROW($T$485:$U$955)-484),1)),\"\")","v":221.04352126607151},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B343,ROW($T$485:$U$955)-484),2)),\"\")","v":-457.01229556074765},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B343,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B343,ROW($T$485:$U$955)-484),4)),\"\")","v":""},1,23,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"23\",ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"23\",ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"23\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"23\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[null,"X",{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B344,ROW($T$485:$U$955)-484),1)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B344,ROW($T$485:$U$955)-484),2)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B344,ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=B344,ROW($T$485:$U$955)-484),4)),\"\")","v":""},0,24,{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"24\",ROW($T$485:$U$955)-484),1)),\"\")","v":-221.04352126607125},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"24\",ROW($T$485:$U$955)-484),2)),\"\")","v":-457.01229556074765},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"24\",ROW($T$485:$U$955)-484),3)),\"\")","v":""},{"$f":"IFERROR(INDEX($R$485:$R$955,SMALL(IF($T$485:$U$955=\"24\",ROW($T$485:$U$955)-484),4)),\"\")","v":""},0]
[]
[]
[]
[null,"Top Node","Node type","Node Comp. Strength(ksi)",null,null,"Bottom Node","Node type","Node Comp. Strength(ksi)"]
[null,"Node A",{"$f":"IF(G321>=2,\"CTT\",IF(G321=1,\"CCT\",\"CCC\"))","v":"CCT"},{"$f":"IF($I$109<$I$110, 0.45*$D$78, IF(C349=\"CCC\",$I$81*$D$78,IF(C349=\"CCT\",$I$82*$D$78,$I$83*$D$78)))","v":1.8},null,null,"Node 2",{"$f":"IF(M322>=2,\"CTT\",IF(M322=1,\"CCT\",\"CCC\"))","v":"CCC"},{"$f":"IF($I$109<$I$110, 0.45*$D$78, IF(H349=\"CCC\",$I$81*$D$78,IF(H349=\"CCT\",$I$82*$D$78,$I$83*$D$78)))","v":1.8}]
[null,"Node B","CCC",1.8,null,null,"Node 1",{"$f":"IF(M321>=2,\"CTT\",IF(M321=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node C","CCC",1.8,null,null,"Node 4",{"$f":"IF(M324>=2,\"CTT\",IF(M324=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node D","CCC",1.8,null,null,"Node 3",{"$f":"IF(M323>=2,\"CTT\",IF(M323=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node E","CTT",1.8,null,null,"Node 6",{"$f":"IF(M326>=2,\"CTT\",IF(M326=1,\"CCT\",\"CCC\"))","v":"CCT"},1.8]
[null,"Node F","CCC",1.8,null,null,"Node 5",{"$f":"IF(M325>=2,\"CTT\",IF(M325=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,{"$f":"IF(OR(C39=0,C40=0), \"Node E\",\"Node G\")","v":"Node E"},"CCC",1.8,null,null,"Node 8",{"$f":"IF(M328>=2,\"CTT\",IF(M328=1,\"CCT\",\"CCC\"))","v":"CCT"},1.8]
[null,"Node H","CCC",1.8,null,null,"Node 7",{"$f":"IF(M327>=2,\"CTT\",IF(M327=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node I","CCC",1.8,null,null,"Node 10",{"$f":"IF(M330>=2,\"CTT\",IF(M330=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node J","CCC",1.8,null,null,"Node 9",{"$f":"IF(M329>=2,\"CTT\",IF(M329=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node K","CTT",1.8,null,null,"Node 12",{"$f":"IF(M332>=2,\"CTT\",IF(M332=1,\"CCT\",\"CCC\"))","v":"CCT"},1.8]
[null,"Node L","CCC",1.8,null,null,"Node 11",{"$f":"IF(M331>=2,\"CTT\",IF(M331=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8,null,null," "]
[null,{"$f":"IF(OR(C42=0,C43=0), \"Node K\",\"Node M\")","v":"Node K"},"CCC",1.8,null,null,"Node 14",{"$f":"IF(M334>=2,\"CTT\",IF(M334=1,\"CCT\",\"CCC\"))","v":"CCT"},1.8]
[null,"Node N","CCC",1.8,null,null,"Node 13",{"$f":"IF(M333>=2,\"CTT\",IF(M333=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node O","CCC",1.8,null,null,"Node 16",{"$f":"IF(M336>=2,\"CTT\",IF(M336=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node P","CCC",1.8,null,null,"Node 15",{"$f":"IF(M335>=2,\"CTT\",IF(M335=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node Q","CTT",1.8,null,null,"Node 18",{"$f":"IF(M338>=2,\"CTT\",IF(M338=1,\"CCT\",\"CCC\"))","v":"CCT"},1.8]
[null,"Node R","CCC",1.8,null,null,"Node 17",{"$f":"IF(M337>=2,\"CTT\",IF(M337=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,{"$f":"IF(OR(C45=0,C46=0), \"Node Q\",\"Node S\")","v":"Node Q"},"CCC",1.8,null,null,"Node 20",{"$f":"IF(M340>=2,\"CTT\",IF(M340=1,\"CCT\",\"CCC\"))","v":"CCT"},1.8]
[null,"Node T","CCC",1.8,null,null,"Node 19",{"$f":"IF(M339>=2,\"CTT\",IF(M339=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node U","CCC",1.8,null,null,"Node 22",{"$f":"IF(M342>=2,\"CTT\",IF(M342=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node V","CCC",1.8,null,null,"Node 21",{"$f":"IF(M341>=2,\"CTT\",IF(M341=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node W","CCT",1.8,null,null,"Node 24",{"$f":"IF(M344>=2,\"CTT\",IF(M344=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[null,"Node X","CCC",1.8,null,null,"Node 23",{"$f":"IF(M343>=2,\"CTT\",IF(M343=1,\"CCT\",\"CCC\"))","v":"CCC"},1.8]
[]
[]
[null,"15. Strut, Tie and Nodal Capacities"]
[]
[null,"Vertical, Top and Bottom Member Capacities"]
[]
[null,"Vertical Member","Vertical Tie Capacity (k)"]
[]
[null,"B-1",{"$f":"IF(OR(Appendix!T78=0,C107=0),0,MAX((I80*D81*C107*D82*(C63-2*0.4663*(G22-D297/2-D298/2))/D107)/1000,0))*1000","v":0}]
[null,"D-3",{"$f":"IF(OR(C108=0,Appendix!T79=0),0,MAX(0,(I80*D81*C108*D82*(C64-2*0.4663*(G22-D297/2-D298/2))/D108)/1000))*1000","v":0}]
[null,"F-5",{"$f":"IF(OR(C109=0,Appendix!T80=0),0,MAX(0,(I80*D81*C109*D82*(C65-2*0.4663*(G22-D297/2-D298/2))/D109)/1000))*1000","v":661.92178577091988}]
[null,"H-7",{"$f":"IF(OR(C110=0,Appendix!T81=0),0,MAX(0,(I80*D81*C110*D82*(C66-2*0.4663*(G22-D297/2-D298/2))/D110)/1000))*1000","v":141.83512535327105}]
[null,"J-9",{"$f":"IF(OR(C111=0,Appendix!T82=0),0,MAX(0,(I80*D81*C111*D82*(C67-2*0.4663*(G22-D297/2-D298/2))/D111)/1000))*1000","v":0}]
[null,"L-11",{"$f":"IF(OR(C112=0,Appendix!T83=0),0,MAX(0,(I80*D81*C112*D82*(C68-2*0.4663*(G22-D297/2-D298/2))/D112)/1000))*1000","v":411.52469544672874}]
[null,"N-13",{"$f":"IF(OR(C113=0,Appendix!T84=0),0,MAX(0,(I80*D81*C113*D82*(C69-2*0.4663*(G22-D297/2-D298/2))/D113)/1000))*1000","v":0}]
[null,"P-15",{"$f":"IF(OR(Appendix!T85=0,C114=0),0,MAX(0,(I80*D81*C114*D82*(C70-2*0.4663*(G22-D297/2-D298/2))/D114)/1000))*1000","v":0}]
[null,"R-17",{"$f":"IF(OR(C115=0,Appendix!T86=0),0,MAX(0,(I80*D81*C115*D82*(C71-2*0.4663*(G22-D297/2-D298/2))/D115)/1000))*1000","v":0}]
[null,"T-19",{"$f":"IF(OR(C116=0,Appendix!T87=0),0,MAX(0,(I80*D81*C116*D82*(C72-2*0.4663*(G22-D297/2-D298/2))/D116)/1000))*1000","v":0}]
[null,"V-21",{"$f":"IF(OR(C117=0,Appendix!T88=0),0,MAX(0,(I80*D81*C117*D82*(C73-2*0.4663*(G22-D297/2-D298/2))/D117)/1000))*1000","v":0}]
[null,"X-23",{"$f":"IF(OR(C118=0,Appendix!T89=0),0,MAX(0,(I80*D81*C118*D82*(C74-2*0.4663*(G22-D297/2-D298/2))/D118)/1000))*1000","v":0}]
[]
[null,"Top & Bottom Members Capacities"]
[null,null,null,"width of the top member =",null,null,{"$f":"D297","v":10}]
[null,null,null,"width of the bottom member =",null,null,{"$f":"D298","v":10}]
[null,null,"Member","Capacity (k)","Node Face Strength",null,"Capacity (k)"]
[null,null,null,null,"Comp. Strength (ksi)","Capacity (k)"]
[null,"Top Members",{"$f":"D181","v":"A-E"},{"$f":"IF(E181>=0,I79*C91*D79/1000*E156,-I79*C91*D79/1000*E156)*1000","v":648},{"$f":"IF(C217=\"Use Tie\",IF(C38<>0,MIN(D350,D351),IF(C221=\"Use Tie\",MIN(D350,D354),MIN(D350,D353))),IF(C38<>0,MIN(D349,D351),IF(C221=\"Use Tie\",MIN(D349,D354),MIN(D3204,D353))))","v":1.8},{"$f":"IF(E181>=0,E399*$G$395*$G$23*$I$78,E399*$G$395*$G$23*-$I$78)","v":453.59999999999997},{"$f":"IF(E181>=0, MIN(D399,F399),D399+F399)","v":453.59999999999997}]
[null,null,"C-E",{"$f":"IF(E182>=0,I79*C92*D79/1000,-I79*C92*D79/1000)*1000","v":648},{"$f":"IF(C219=\"Use Tie\",IF(C221=\"Use Tie\",MIN(D352,D354),MIN(D352,D353)),IF(C221=\"Use Tie\",MIN(D351,D354),MIN(D351,D353)))","v":1.8},{"$f":"IF(E182>=0,E400*$G$395*$G$23*$I$78,E400*$G$395*$G$23*-$I$78)","v":453.59999999999997},{"$f":"IF(E182>=0, MIN(D400,F400),D400+F400)","v":453.59999999999997}]
[null,null,"E-K",{"$f":"IF(E183>=0,I79*C93*D79/1000,-I79*C93*D79/1000)*1000","v":648},{"$f":"IF(OR(C39=0,C40=0),IF(C223=\"Use Tie\",MIN(D355,D356),IF(C41<>0,MIN(D355,D357),IF(C227=\"Use Tie\",MIN(D355,D360),MIN(D355,D359)))),MIN(D353,D359))","v":1.8},453.59999999999997,453.59999999999997]
[null,null,"E-K",{"$f":"IF(E184>=0,I79*C94*D79/1000,-I79*C94*D79/1000)*1000","v":648},{"$f":"IF(C223=\"Use Tie\",IF(C41<>0,MIN(D356,D357),IF(C227=\"Use Tie\",MIN(D356,D360),MIN(D356,D359))),IF(C41<>0,MIN(D355,D357),IF(C227=\"Use Tie\",MIN(D355,D360),MIN(D355,D359))))","v":1.8},453.59999999999997,453.59999999999997]
[null,null,"I-K",{"$f":"IF(E185>=0,I79*C95*D79/1000,-I79*C95*D79/1000)*1000","v":648},{"$f":"IF(C225=\"Use Tie\",IF(C225=\"Use Tie\",MIN(D358,D360),MIN(D358,D359)),IF(C227=\"Use Tie\",MIN(D357,D360),MIN(D357,D359)))","v":1.8},453.59999999999997,453.59999999999997]
[null,null,"K-Q",{"$f":"IF(E186>=0,I79*C96*D79/1000,-I79*C96*D79/1000)*1000","v":648},{"$f":"IF(OR(C42=0,C43=0),IF(C229=\"Use Tie\",MIN(D361,D362),IF(C44<>0,MIN(D361,D363),IF(C233=\"Use Tie\",MIN(D361,D366),MIN(D361,D365)))),MIN(D359,D361))","v":1.8},453.59999999999997,453.59999999999997]
[null,null,"K-Q",{"$f":"IF(E187>=0,I79*C97*D79/1000,-I79*C97*D79/1000)*1000","v":0},{"$f":"IF(C229=\"Use Tie\",IF(C44<>0,MIN(D362,D363),IF(C233=\"Use Tie\",MIN(D362,D366),MIN(D362,D365))),IF(C44<>0,MIN(D361,D363),IF(C233=\"Use Tie\",MIN(D361,D366),MIN(D361,D365))))","v":1.8},453.59999999999997,0]
[null,null,"O-Q",{"$f":"IF(E188>=0,I79*C98*D79/1000,-I79*C98*D79/1000)*1000","v":0},{"$f":"IF(C231=\"Use Tie\",IF(C233=\"Use Tie\",MIN(D364,D366),MIN(D364,D365)),IF(C233=\"Use Tie\",MIN(D363,D366),MIN(D363,D365)))","v":1.8},453.59999999999997,0]
[null,null,"Q-W",{"$f":"IF(E189>=0,I79*C99*D79/1000,-I79*C99*D79/1000)*1000","v":0},{"$f":"IF(OR(C45=0,C46=0),IF(C235=\"Use Tie\",MIN(D367,D368),IF(C47<>0,MIN(D367,D369),IF(C239=\"Use Tie\",MIN(D367,D372),MIN(D367,D371)))),MIN(D365,D367))","v":1.8},453.59999999999997,0]
[null,null,"Q-W",{"$f":"IF(E190>=0,I79*C100*D79/1000,-I79*C100*D79/1000)*1000","v":0},{"$f":"IF(C235=\"Use Tie\",IF(C47<>0,MIN(D368,D369),IF(C239=\"Use Tie\",MIN(D368,D372),MIN(D368,D371))),IF(C47<>0,MIN(D367,D369),IF(C239=\"Use Tie\",MIN(D367,D372),MIN(D367,D371))))","v":1.8},453.59999999999997,0]
[null,null,"U-W",{"$f":"IF(E191>=0,I79*C101*D79/1000,-I79*C101*D79/1000)*1000","v":0},{"$f":"IF(C237=\"Use Tie\",IF(C239=\"Use Tie\",MIN(D370,D372),MIN(D370,D371)),IF(C239=\"Use Tie\",MIN(D369,D372),MIN(D369,D371)))","v":1.8},453.59999999999997,0]
[null,null,"W+",{"$f":"IF(E192>=0,I79*C102*D79/1000,-I79*C102*D79/1000)*1000","v":0},{"$f":"D371","v":1.8},453.59999999999997,0]
[null,"Bottom Members","2-6",{"$f":"IF(E193>=0,I79*E91*D79/1000*E156,-I79*E91*D79/1000*E156)*1000","v":-648},{"$f":"IF(C38<>0,IF(C219=\"Use Tie\",MIN(I349,I352),MIN(I349,I351)),MIN(I349,I353))","v":1.8},{"$f":"IF(E193>=0,E411*$G$396*$G$23*$I$78,E411*$G$396*$G$23*-$I$78)","v":-453.59999999999997},-1101.5999999999999]
[null,null,"4-6",{"$f":"IF(E194>=0,I79*E92*D79/1000,-I79*E92*D79/1000)*1000","v":648},{"$f":"MIN(I351,I353)","v":1.8},{"$f":"IF(E194>=0,E412*$G$396*$G$23*$I$78,E412*$G$396*$G$23*-$I$78)","v":453.59999999999997},453.59999999999997]
[null,null,"6-8",{"$f":"IF(E195>=0,I79*E93*D79/1000,-I79*E93*D79/1000)*1000","v":648},{"$f":"IF(C221=\"Use Tie\",IF(C223=\"Use Tie\",MIN(I354,I356),MIN(I354,I355)),IF(C223=\"Use Tie\",MIN(I353,I356),MIN(I353,I355)))","v":1.8},453.59999999999997,453.59999999999997]
[null,null,"8-12",{"$f":"IF(E196>=0,I79*E94*D79/1000,-I79*E94*D79/1000)*1000","v":-648},{"$f":"IF(C41<>0,IF(C225=\"Use Tie\",MIN(I355,I358),MIN(I355,I357)),MIN(I355,I359))","v":1.8},-453.59999999999997,-1101.5999999999999]
[null,null,"10-12",{"$f":"IF(E197>=0,I79*E95*D79/1000,-I79*E95*D79/1000)*1000","v":648},{"$f":"MIN(I357,I359)","v":1.8},453.59999999999997,453.59999999999997]
[null,null,"12-14",{"$f":"IF(E198>=0,I79*E96*D79/1000,-I79*E96*D79/1000)*1000","v":648},{"$f":"IF(C227=\"Use Tie\",IF(C229=\"Use Tie\",MIN(I360,I362),MIN(I360,I361)),IF(C229=\"Use Tie\",MIN(I359,I362),MIN(I359,I361)))","v":1.8},453.59999999999997,453.59999999999997]
[null,null,"14-18",{"$f":"IF(E199>=0,I79*E97*D79/1000,-I79*E97*D79/1000)*1000","v":0},{"$f":"IF(C44<>0,IF(C231=\"Use Tie\",MIN(I361,I364),MIN(I361,I363)),MIN(I361,I365))","v":1.8},-453.59999999999997,-453.59999999999997]
[null,null,"16-18",{"$f":"IF(E200>=0,I79*E98*D79/1000,-I79*E98*D79/1000)*1000","v":0},{"$f":"MIN(I363,I365)","v":1.8},453.59999999999997,0]
[null,null,"18-20",{"$f":"IF(E201>=0,I79*E99*D79/1000,-I79*E99*D79/1000)*1000","v":0},{"$f":"IF(C233=\"Use Tie\",IF(C235=\"Use Tie\",MIN(I366,I368),MIN(I366,I367)),IF(C235=\"Use Tie\",MIN(I365,I368),MIN(I365,I367)))","v":1.8},453.59999999999997,0]
[null,null,"20-24",{"$f":"IF(E202>=0,I79*E100*D79/1000,-I79*E100*D79/1000)*1000","v":0},{"$f":"IF(C47<>0,IF(C237=\"Use Tie\",MIN(I367,I370),MIN(I367,I369)),MIN(I367,I371))","v":1.8},-453.59999999999997,-453.59999999999997]
[null,null,"22-24",{"$f":"IF(E203>=0,I79*E101*D79/1000,-I79*E101*D79/1000)*1000","v":0},{"$f":"MIN(I369,I371)","v":1.8},453.59999999999997,0]
[null,null,"24+",{"$f":"IF(E204>=0,I79*E102*D79/1000,-I79*E102*D79/1000)*1000","v":0},{"$f":"I372","v":1.8},453.59999999999997,0]
[]
[]
[null,"Inclined Members Capacities"]
[]
[null,null,"Limiting Compressive Stresses (fcu) ",null,null,{"$f":"MAX(MIN(0.85-D78/20, 0.65), 0.45)","v":0.64999999999999991}]
[null,null,"Inclined Member","α","Width of Inclined Node (in.)","Width of Inclined Node from vertical tie","Inclined Member Capacity (k)"]
[]
[null,"If Vertical Ties Used","A-1",{"$f":"IF(C37=0, 0, MIN(F301/C37, 1))","v":1},{"$f":"IF(C301=0,0,F$122*D430*SIN(ABS(J301))+D$297*COS(ABS(J301)))","v":18.085383632679363},{"$f":"MAX((C63-2*0.4663*(G$22-G$395/2-G$396/2))*ABS(SIN(J301)),0)","v":0},{"$f":"IF($I$109<$I$110,-I$78*0.45*$D$78*MIN(E430,F430)*G$23,-I$78*F$427*D$78*MIN(E430,F430)*G$23)","v":0}]
[null,null,"B-2",1,{"$f":"IF(C301=0,0,(C301*SIN(ABS(J301))+$D$298*COS(ABS(J301))))","v":28.919774457487343},{"$f":"F430","v":0},0]
[null,null,"C-3",{"$f":"IF(C38=0, 0, MIN(F302/C38, 1))","v":0},{"$f":"IF(C302=0,0,F$122*D432*SIN(ABS(J302))+D$297*COS(ABS(J302)))","v":0},{"$f":"MAX((C64-2*0.4663*(G$22-G$395/2-G$396/2))*ABS(SIN(J302)),0)","v":0},0]
[null,null,"D-4",1,{"$f":"IF(C302=0,0,(C302*SIN(ABS(J302))+$D$298*COS(ABS(J302))))","v":0},{"$f":"F432","v":0},0]
[null,null,"E-5",{"$f":"IF(C39=0, 0, MIN(F303/C39, 1))","v":0.3215686274509803},{"$f":"IF(C303=0,0,F$122*D434*SIN(ABS(J303))+D$297*COS(ABS(J303)))","v":11.213053767955902},{"$f":"MAX((C65-2*0.4663*(G$22-G$395/2-G$396/2))*ABS(SIN(J303)),0)","v":46.633358987861591},-508.62411891447971]
[null,null,"F-6",1,{"$f":"IF(C303=0,0,(C303*SIN(ABS(J303))+$D$298*COS(ABS(J303))))","v":13.107650136023523},{"$f":"F434","v":46.633358987861591},-594.56301017002704]
[null,null,"G-7",{"$f":"IF(C40=0, MIN(F304/C39, 1), MIN(F304/C40, 1))","v":0.67843137254901964},{"$f":"IF(C304=0,0,F$122*D436*SIN(ABS(J304))+D$297*COS(ABS(J304)))","v":14.64567126753402},{"$f":"MAX((C66-2*0.4663*(G$22-G$395/2-G$396/2))*ABS(SIN(J304)),0)","v":15.511128768050609},-664.3276486953431]
[null,null,"H-8",1,{"$f":"IF(C304=0,0,(C304*SIN(ABS(J304))+$D$298*COS(ABS(J304))))","v":17.653293189800731},{"$f":"F436","v":15.511128768050609},-703.58480091877573]
[null,null,"I-9",{"$f":"IF(C41=0, 0, MIN(F305/C41, 1))","v":0},{"$f":"IF(C305=0,0,F$122*D438*SIN(ABS(J305))+D$297*COS(ABS(J305)))","v":0},{"$f":"MAX((C67-2*0.4663*(G$22-G$395/2-G$396/2))*ABS(SIN(J305)),0)","v":0},0]
[null,null,"J-10",1,{"$f":"IF(C305=0,0,(C305*SIN(ABS(J305))+$D$298*COS(ABS(J305))))","v":0},{"$f":"F438","v":0},0]
[null,null,"K-11",{"$f":"IF(C42=0, 0, MIN(F306/C42, 1))","v":1},{"$f":"IF(C306=0,0,F$122*D440*SIN(ABS(J306))+D$297*COS(ABS(J306)))","v":17.957654470615722},{"$f":"MAX((C68-2*0.4663*(G$22-G$395/2-G$396/2))*ABS(SIN(J306)),0)","v":35.646040789590842},-814.55920678712914]
[null,null,"L-12",1,{"$f":"IF(C306=0,0,(C306*SIN(ABS(J306))+$D$298*COS(ABS(J306))))","v":21.46899630028085},{"$f":"F440","v":35.646040789590842},-973.83367218073931]
[null,null,"M-13",{"$f":"IF(C43=0, MIN(F307/C42, 1), MIN(F307/C43, 1))","v":0},{"$f":"IF(C307=0,0,F$122*D442*SIN(ABS(J307))+D$297*COS(ABS(J307)))","v":0},{"$f":"MAX((C69-2*0.4663*(G$22-G$395/2-G$396/2))*ABS(SIN(J307)),0)","v":0},0]
[null,null,"N-14",1,{"$f":"IF(C307=0,0,(C307*SIN(ABS(J307))+$D$298*COS(ABS(J307))))","v":0},{"$f":"F442","v":0},0]
[null,null,"O-15",{"$f":"IF(C44=0, 0, MIN(F308/C44, 1))","v":0},{"$f":"IF(C308=0,0,F$122*D444*SIN(ABS(J308))+D$297*COS(ABS(J308)))","v":0},{"$f":"MAX((C70-2*0.4663*(G$22-G$395/2-G$396/2))*ABS(SIN(J308)),0)","v":0},0]
[null,null,"P-16",1,{"$f":"IF(C308=0,0,(C308*SIN(ABS(J308))+$D$298*COS(ABS(J308))))","v":0},{"$f":"F444","v":0},0]
[null,null,"Q-17",{"$f":"IF(C45=0, 0, MIN(F309/C45, 1))","v":0},{"$f":"IF(C309=0,0,F$122*D446*SIN(ABS(J309))+D$297*COS(ABS(J309)))","v":0},{"$f":"MAX((C71-2*0.4663*(G$22-G$395/2-G$396/2))*ABS(SIN(J309)),0)","v":0},0]
[null,null,"R-18",1,{"$f":"IF(C309=0,0,(C309*SIN(ABS(J309))+$D$298*COS(ABS(J309))))","v":0},{"$f":"F446","v":0},0]
[null,null,"S-19",{"$f":"IF(C46=0, MIN(F310/C45, 1), MIN(F310/C46, 1))","v":{"$error":"#DIV/0!"}},{"$f":"IF(C310=0,0,F$122*D448*SIN(ABS(J310))+D$297*COS(ABS(J310)))","v":0},{"$f":"MAX((C72-2*0.4663*(G$22-G$395/2-G$396/2))*ABS(SIN(J310)),0)","v":0},0]
[null,null,"T-20",1,{"$f":"IF(C310=0,0,(C310*SIN(ABS(J310))+$D$298*COS(ABS(J310))))","v":0},{"$f":"F448","v":0},0]
[null,null,"U-21",{"$f":"IF(C47=0, 0, MIN(F311/C47, 1))","v":0},{"$f":"IF(C311=0,0,F$122*D450*SIN(ABS(J311))+D$297*COS(ABS(J311)))","v":0},{"$f":"MAX((C73-2*0.4663*(G$22-G$395/2-G$396/2))*ABS(SIN(J311)),0)","v":0},0]
[null,null,"V-22",1,{"$f":"IF(C311=0,0,(C311*SIN(ABS(J311))+$D$298*COS(ABS(J311))))","v":0},{"$f":"F450","v":0},0]
[null,null,"W-23",{"$f":"IF(C48=0, 0, MIN(F312/C48, 1))","v":0},{"$f":"IF(C312=0,0,F$122*D452*SIN(ABS(J312))+D$297*COS(ABS(J312)))","v":0},{"$f":"MAX((C74-2*0.4663*(G$22-G$395/2-G$396/2))*ABS(SIN(J312)),0)","v":0},0]
[null,null,"X-24",1,{"$f":"IF(C312=0,0,(C312*SIN(ABS(J312))+$D$298*COS(ABS(J312))))","v":0},{"$f":"F452","v":0},0]
[null,"If Vertical Ties Not Used","A-2",{"$f":"D430","v":1},{"$f":"IF(F301=0,0,MIN(F122*D430*SIN(ABS(M301))+D297*COS(ABS(M301)),C301*SIN(ABS(M301))+D298*COS(ABS(M301))))","v":18.840707999105},null,{"$f":"IF($I$109<$I$110,-I$78*0.45*$D$78*E454*G$23,-I$78*F$427*D$78*E454*G$23)","v":-854.61451483940277}]
[null,null,"C-4",{"$f":"D432","v":0},{"$f":"IF(F302=0,0,MIN(F122*D432*SIN(ABS(M302))+D297*COS(ABS(M302)),(C302*SIN(ABS(M302))+D298*COS(ABS(M302)))))","v":0},null,0]
[null,null,"E-6",{"$f":"D434","v":0.3215686274509803},{"$f":"IF(F303=0,0,MIN(F122*D434*SIN(ABS(M303))+D297*COS(ABS(M303)),C303*SIN(ABS(M303))+D298*COS(ABS(M303))))","v":11.070980447282986},null,-502.1796730887562]
[null,null,{"$f":"IF(OR(C39=0,C40=0), \"E-8\",\"G-8\")","v":"E-8"},{"$f":"D436","v":0.67843137254901964},{"$f":"IF(F304=0,0,MIN(F122*D436*SIN(ABS(M304))+D297*COS(ABS(M304)),C304*SIN(ABS(M304))+D298*COS(ABS(M304))))","v":14.416694746545394},null,-653.94127370329909]
[null,null,"I-10",{"$f":"D438","v":0},{"$f":"IF(F305=0,0,MIN(F122*D438*SIN(ABS(M305))+D297*COS(ABS(M305)),C305*SIN(ABS(M305))+D298*COS(ABS(M305))))","v":0},null,0]
[null,null,"K-12",{"$f":"D440","v":1},{"$f":"IF(F306=0,0,MIN(F122*D440*SIN(ABS(M306))+D297*COS(ABS(M306)),C306*SIN(ABS(M306))+D298*COS(ABS(M306))))","v":15.428492977836207},null,-699.83644147465031]
[null,null,{"$f":"IF(OR(C42=0,C43=0), \"K-14\",\"M-14\")","v":"K-14"},{"$f":"D442","v":0},{"$f":"IF(F307=0,0,MIN(F122*D442*SIN(ABS(M307))+D297*COS(ABS(M307)),C307*SIN(ABS(M307))+D298*COS(ABS(M307))))","v":0},null,0]
[null,null,"O-16",{"$f":"D444","v":0},{"$f":"IF(F308=0,0,MIN(F122*D444*SIN(ABS(M308))+D297*COS(ABS(M308)),C308*SIN(ABS(M308))+D298*COS(ABS(M308))))","v":0},null,0]
[null,null,"Q-18",{"$f":"D446","v":0},{"$f":"IF(F309=0,0,MIN(F122*D446*SIN(ABS(M309))+D297*COS(ABS(M309)),C309*SIN(ABS(M309))+D298*COS(ABS(M309))))","v":0},null,0]
[null,null,{"$f":"IF(OR(C45=0,C46=0), \"Q-20\",\"S-20\")","v":"Q-20"},{"$f":"D448","v":{"$error":"#DIV/0!"}},{"$f":"IF(F310=0,0,MIN(F122*D448*SIN(ABS(M310))+D297*COS(ABS(M310)),C310*SIN(ABS(M310))+D298*COS(ABS(M310))))","v":0},null,0]
[null,null,"U-22",{"$f":"D450","v":0},{"$f":"IF(F311=0,0,MIN(F122*D450*SIN(ABS(M311))+D297*COS(ABS(M311)),C311*SIN(ABS(M311))+D298*COS(ABS(M311))))","v":0},null,0]
[null,null,"W-24.",{"$f":"D452","v":0},{"$f":"IF(F312=0,0,MIN(F122*D452*SIN(ABS(M312))+D297*COS(ABS(M312)),C312*SIN(ABS(M312))+D298*COS(ABS(M312))))","v":0},null,0]
[]
[]
[]
[]
[null,"16. Strut and Tie Member Forces (from the Matrix Stiffness Method)"]
[]
[null,"Symmetrical",null,null,null,null,null,null,null,null,null,"Non Zeros Loads in Sequential Order",null,null,null,null,null,null,null,"Asymmetrical",null,null,null,null,null,null,null,null,null,"Non Zeros Loads in Sequential Order"]
[null,"Truss Nodes/Joints",null,null,null,"Pier Cap Info",null,null,null,null,null,{"$f":"IF(ROWS(B$1:B1)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B1))))","v":400},null,null,null,null,null,null,null,"Truss Nodes/Joints",null,null,null,"Pier Cap Info",null,null,null,null,null,{"$f":"IF(ROWS(B$1:B1)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B1))))","v":400}]
[null,"Top Nodes",null,{"$f":" 2*COUNTIF(C37:C48,\"<>0\")-IF(ABS(H29-E57)<=0.02*H29,1,0)+COUNTIF(Appendix!A36:A47,\"Use Tie\")*2","v":5},null,"Top Node y Coordinate",null,null,{"$f":"G22-D297/2","v":43.4},null,null,{"$f":"IF(ROWS(B$1:B2)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B2))))","v":400},null,null,null,null,null,null,null,"Top Nodes",null,{"$f":" COUNTIF(C37:C48,\"<>0\")+COUNTIF(Appendix!A36:A47,\"Use Tie\")","v":3},null,"Top Node y Coordinate",null,null,{"$f":"G22-D297/2","v":43.4},null,null,{"$f":"IF(ROWS(B$1:B2)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B2))))","v":400}]
[null,"Bottom Nodes",null,{"$f":"2*COUNTIF(C301:C312,\"<>0\")-IF(AND(ABS(H29-E57)<=0.02*H29,MOD(G9,2)=1),1,0)+COUNTIF(Appendix!A36:A47,\"Use Tie\")*2","v":8},null,"Bottom node y coordinate",null,null,{"$f":"D298/2","v":5},null,null,{"$f":"IF(ROWS(B$1:B3)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B3))))","v":400},null,null,null,null,null,null,null,"Bottom Nodes",null,{"$f":"COUNTIF(C301:C312,\"<>0\")+COUNTIF(Appendix!A36:A47,\"Use Tie\")","v":4},null,"Bottom node y coordinate",null,null,{"$f":"D298/2","v":5},null,null,{"$f":"IF(ROWS(B$1:B3)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B3))))","v":400}]
[null,"Total Number of Nodes",null,{"$f":"D474+D475","v":13},null,null,null,null,null,null,null,{"$f":"IF(ROWS(B$1:B4)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B4))))","v":""},null,null,null,null,null,null,null,"Total Number of Nodes",null,{"$f":"V474+V475","v":7},null,null,null,null,null,null,null,{"$f":"IF(ROWS(B$1:B4)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B4))))","v":""}]
[null,"Truss Members",null,null,null,"Total length of half pier cap",null,null,{"$f":"SUM(I16:I20)","v":354},null,null,{"$f":"IF(ROWS(B$1:B5)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B5))))","v":""},null,null,null,null,null,null,null,"Truss Members",null,null,null,"Total length of half pier cap",null,null,{"$f":"SUM(I16:I20)","v":354},null,null,{"$f":"IF(ROWS(B$1:B5)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B5))))","v":""}]
[null,"Top Members",null,{"$f":"D474-1","v":4},null,null,null,null,null,null,null,{"$f":"IF(ROWS(B$1:B6)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B6))))","v":""},null,null,null,null,null,null,null,"Top Members",null,{"$f":"V474-1","v":2},null,null,null,null,null,null,null,{"$f":"IF(ROWS(B$1:B6)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B6))))","v":""}]
[null,"Bottom Members",null,{"$f":"D475-1","v":7},null,"Total Possible Number of reaction",null,null,{"$f":"INT(3*G9)","v":12},null,null,{"$f":"IF(ROWS(B$1:B7)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B7))))","v":""},null,null,null,null,null,null,null,"Bottom Members",null,{"$f":"V475-1","v":3},null,"Total Possible Number of reaction",null,null,{"$f":"INT(3*G9)","v":12},null,null,{"$f":"IF(ROWS(B$1:B7)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B7))))","v":""}]
[null,"Inclined Members",null,{"$f":"D475","v":8},null,"Number of Support Reactions",null,null,{"$f":"2*COUNTIF(C301:C312,\"<>0\")-IF(AND(ABS(H29-E57)<=0.02*H29,MOD(G9,2)=1),1,0)","v":8},null,null,{"$f":"IF(ROWS(B$1:B8)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B8))))","v":""},null,null,null,null,null,null,null,"Inclined Members",null,{"$f":"V475","v":4},null,"Number of Support Reactions",null,null,{"$f":"COUNTIF(C301:C312,\"<>0\")","v":4},null,null,{"$f":"IF(ROWS(B$1:B8)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B8))))","v":""}]
[null,"Vertical Members",null,{"$f":"COUNTIF(Appendix!A36:A47,\"Use Tie\")*2","v":0},null,"Number of Point Loads Applied",null,null,{"$f":" 2*COUNTIF(C37:C48,\"<>0\")-IF(ABS(H29-E57)<=0.02*H29,1,0)","v":5},null,null,{"$f":"IF(ROWS(B$1:B9)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B9))))","v":""},null,null,null,null,null,null,null,"Vertical Members",null,{"$f":"COUNTIF(Appendix!A36:A47,\"Use Tie\")","v":0},null,"Number of Point Loads Applied",null,null,{"$f":" COUNTIF(C37:C48,\"<>0\")","v":3},null,null,{"$f":"IF(ROWS(B$1:B9)>COUNTIF(C$37:C$48,\">0\"),\"\",INDEX(C$37:C$48,SMALL(IF(C$37:C$48>0,ROW(C$37:C$48)-ROW(C$37)+1),ROWS(B$1:B9))))","v":""}]
[null,"Total Number of Member",null,{"$f":"SUM(D478:D481)","v":19},null,null,null,null,null,null,null,null,null,"Output",null,null,null,null,null,"Total Number of Member",null,{"$f":"SUM(V478:V481)","v":9}]
[null,"Connectivity",null,null,"Nodal Coordinate",null,null,"Point Loads",null,null,"Support Condition",null,null,"Reaction",null,null,"Member Forces","Output Strings",null,"Breaking the member strings"]
[null,"Bar","Start","End","Nodes","X ","Y","Nodes","X","Y","Nodes","X Restraint","Y Restraint","Node","X ","Y ","Bar","Force","Member"]
[null,1,1,2,1,43.620178041543028,5,1,0,0,1,1,1,1,3.8236080968090391E-13,400.00000000000017,1,-221.04352126607358,"2-6",{"$f":"IFERROR(LEFT(S485,FIND(\"-\",S485)-1),0)","v":"2"},{"$f":"IFERROR(RIGHT(S485,LEN(S485)-FIND(\"-\",S485)),0)","v":"6"},""]
[null,2,2,3,2,61.620178041543028,5,2,0,0,2,0,1,2,null,105.83973047739521,2,122.8799872000793,"6-8",{"$f":"IFERROR(LEFT(S486,FIND(\"-\",S486)-1),0)","v":"6"},{"$f":"IFERROR(RIGHT(S486,LEN(S486)-FIND(\"-\",S486)),0)","v":"8"},""]
[null,3,3,4,3,241.27570093457945,5,3,0,0,3,0,1,3,null,294.16026952260484,3,-297.49113199673707,"8-12","8","12",""]
[null,4,4,5,4,259.27570093457945,5,4,0,0,4,0,1,4,null,200.00000000000099,4,195.86459230232666,"12-14","12","14",""]
[null,5,5,6,5,448.72429906542055,5,5,0,0,5,0,1,5,null,199.99999999999892,5,-297.49113199673673,"14-18","14","18",""]
[null,6,6,7,6,466.72429906542055,5,6,0,0,6,0,1,6,null,294.16026952260665,6,122.87998720007985,"18-20","18","20",""]
[null,7,7,8,7,646.379821958457,5,7,0,0,7,0,1,7,null,105.83973047739336,7,-221.04352126607125,"20-24","20","24",""]
[null,8,9,10,8,664.379821958457,5,8,0,0,8,0,1,8,null,399.99999999999972,8,221.0435212660731,"A-E","A","E",""]
[null,9,10,11,9,22.4,43.4,9,0,-400,9,0,0,9,null,null,9,297.4911319967365,"E-K","E","K",""]
[null,10,11,12,10,186.4,43.4,10,0,-400,10,0,0,10,null,null,10,297.49113199673582,"K-Q","K","Q",""]
[null,11,12,13,11,354,43.4,11,0,-400,11,0,0,11,null,null,11,221.04352126607151,"Q-W","Q","W",""]
[null,12,9,1,12,521.6,43.4,12,0,-400,12,0,0,12,null,null,12,-457.01229556074861,"A-2","A","2",""]
[null,13,10,2,13,685.6,43.4,13,0,-400,13,0,0,13,null,null,13,-359.84083734784139,"E-6","E","6",""]
[null,14,10,3,null,null,null,null,null,null,null,null,null,null,null,null,14,-513.0712835663245,"E-8","E","8",""]
[null,15,11,4,null,null,null,null,null,null,null,null,null,null,null,null,15,-532.35314472505331,"K-12","K","12",""]
[null,16,11,5,null,null,null,null,null,null,null,null,null,null,null,null,16,-532.35314472505195,"K-14","K","14",""]
[null,17,12,6,null,null,null,null,null,null,null,null,null,null,null,null,17,-513.07128356632506,"Q-18","Q","18",""]
[null,18,12,7,null,null,null,null,null,null,null,null,null,null,null,null,18,-359.84083734783997,"Q-20","Q","20",""]
[null,19,13,8,null,null,null,null,null,null,null,null,null,null,null,null,19,-457.01229556074765,"W-24","W","24",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,-457.01229556074821,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,-233.18653239910256,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,122.24113103818129,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,-232.1577396434291,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,-485.20105259503856,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,-310.98903489316996,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,200.0000000000006,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,-324.2395617483736,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,-324.23956174837298,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,199.9999999999994,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,-310.98903489316916,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,-485.2010525950389,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,-232.15773964342745,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,122.24113103817973,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,-233.18653239910105,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,-457.0122955607481,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,-310.98903489316916,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,-341.62780021466051,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,279.46150189090844,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,-345.86497209508775,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,-228.92413562731022,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,120.53849810909148,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42,-229.93859886551277,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,-457.01229556074787,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,229.39581549723493,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45,-280.47679499386339,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(LEFT(S550,FIND(\"-\",S550)-1),0)","v":0},{"$f":"IFERROR(RIGHT(S550,LEN(S550)-FIND(\"-\",S550)),0)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(LEFT(S614,FIND(\"-\",S614)-1),0)","v":0},{"$f":"IFERROR(RIGHT(S614,LEN(S614)-FIND(\"-\",S614)),0)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(LEFT(S678,FIND(\"-\",S678)-1),0)","v":0},{"$f":"IFERROR(RIGHT(S678,LEN(S678)-FIND(\"-\",S678)),0)","v":0},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(LEFT(S742,FIND(\"-\",S742)-1),0)","v":0},{"$f":"IFERROR(RIGHT(S742,LEN(S742)-FIND(\"-\",S742)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(LEFT(S806,FIND(\"-\",S806)-1),0)","v":0},{"$f":"IFERROR(RIGHT(S806,LEN(S806)-FIND(\"-\",S806)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(LEFT(S870,FIND(\"-\",S870)-1),0)","v":0},{"$f":"IFERROR(RIGHT(S870,LEN(S870)-FIND(\"-\",S870)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"IFERROR(LEFT(S934,FIND(\"-\",S934)-1),0)","v":0},{"$f":"IFERROR(RIGHT(S934,LEN(S934)-FIND(\"-\",S934)),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Commentary","index":1,"n_rows":134,"n_cols":13,"rows_kept":134,"cut":false,"hidden":false,"merged":[[133,1,134,10],[128,1,129,10],[14,1,18,10],[99,1,104,10],[82,1,87,10],[77,1,79,10],[94,1,97,10],[109,1,112,10],[105,1,106,10],[131,1,131,10],[88,1,92,10],[114,1,126,10],[20,1,32,10],[34,1,43,10],[1,1,2,10],[74,1,74,10],[75,1,75,10],[49,1,50,10],[4,1,8,10],[69,1,72,10],[10,1,12,10],[45,1,47,10]]}
["Commentary Section"]
["Reset Button","This button makes all input 0 ‘zero’ and deletes all input and output graphics. It is recommended to click on ‘Reset All Data’ whenever a new pier cap is being analyzed."]
[]
[]
["Section 1.","This is the total number of supporting columns (i.e., piers) in a full pier cap. This analyzes symmetrical as well as asymmetrical pier caps. If the pier cap being analyzed is asymmetrical, a check mark is provided. The spreadsheet is designed to analyze a maximum number of eight columns for symmetrical pier caps and maximum of four columns for asymmetrical pier caps. For symmetrical pier caps, the input and output of the analysis are limited up to the centerline, while for asymmetrical pier caps, the full pier cap analysis is performed."]
[]
[]
[]
[]
[]
["Section 2.","‘2. Generate’ is a form control button, which runs VBA codes in the background to generate a sketch depending upon the number of piers. The further input in Section 3 and Section 4 are made to be based on the generated sketch. Also, the input fields are highlighted depending upon the number of piers."]
[]
[]
[]
["Section 3.","This section requires the input of geometrical details of the pier cap and columns. For symmetrical pier caps, the input variables are required only up to centerline but for asymmetrical pier cap, full pier cap input variable are required. From the pier cap drawings, look for the values of variables C1, C2… W, t, h, etc. The other inputs except column width (W) are straight forward. The input for column width (W) requires identification if the column is circular or square. Select circular or square from the drop down list."]
[]
[]
[]
[]
[]
["Section 4.","These loads are the girder loads that are transferred to the cap beam and the spacing between each girder loads are input. The self-weight of the pier cap are not automatically considered by STM-CAP. It can be added manually to the applied loads. Applying the entire self-weight from the top of the beam may be conservative. Only half may be applied and the other half (representing the lower half of the beam) may be assumed to directly do into the column supports, without stressing the struts and ties. There are three options available:\nOption 1: If each girder loads and the spacing between the girders are same; go with this option:\nIf this is the case, there are just 3 input to be made. Input the distance from the edge of pier cap to the first girder load as first input in feet and inches. Also, input the constant spacing between the girders as second input and constant girder factored loads as third input. Then press 'Generate Load Table' Button.  This will populate the below 'Factored Load and Distance' table itself. Note: These factored loads depends upon different load combination based on AASHTO LRFD 2017. \nOption 2: If the spacing between the girders are same but the factored girder loads are different, the process is same as 'Option 1'. After the table is populated, change the load values in the 'Factored Load' column of the table  to the new factored girder loads.\nOption 3: If the spacing between the girders are different, then the input should be done manually based on regions:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The regions are divided as shown in Fig. 1 For every individual column, there are three regions: left, middle, and right. The left regions start from the edge of a pier cap (e.g., R1) or from the mid-point of a span (e.g., R4) to the first edge of the column. The middle regions are the regions just above the columns (e.g., R2, R5). The right regions goes from the ends of middle regions to the mid-point of the next span. The load in Region 1  is referred to as P1 and so on. If any of the regions do not have a load, input a value of 0 'zero'. Also, the corresponding distance A should be input as 0 'zero'.  If any load  (Pn) is 0 'zero', then the corresponding distance (An) should also be input as 0 'zero'. In Fig. 2, there is no load in Region 2; therefore, P2 = 0 and A2 = 0. Similarly, P5 and A5 equals to zero and so on. If there is only load in  mid-span, it can be input as [P3, A3] or [P4, A4]. If mid-span has two loads, the first load is input as [P3, A3] and the second load as [P4, A4].\nThe distance (A1, A2, A3, etc.) are the distances between the loads. The first distance would be the distance from the left edge of the pier cap to the girder load; the other distances are the spacing between the girders, simply can be referred as girder spacing. "]
[null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Section 5.","‘5. Generate’ is a form control button which  generates a sketch depending upon the input made for geometry details and load details. A message is displayed to confirm the accuracy of the generated drawing. If any mistake is noticed, it is required to re-input Section 3 & Section 4 and generate again."]
[]
[]
[]
["Section 6.","This section indicates whether the pier cap is deep or slender. For a slender regions, this spreadsheet can still be used, but the traditional sectional analysis will give larger capacities for slender regions. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For shear  span-to-depth ratios (a/d) less than 2.0 (i.e., deep beams) as shown in Fig. 3, this spreadsheet will provide more accurate result and less conservative results. Note: Shear span is the distance from the point of application of concentrated force to its respective reaction force (i.e., supporting column) as shown in Fig. 4. The depth is the effective depth of the member (i.e., the distance from the extreme compression fiber to the centroid of the tension reinforcement)."]
[]
[]
[]
[]
["Section 7.","This section requires the input of material properties (f'c, fy, fy,stirrup)"]
[null,"Stirrup Area: This corresponds to the sectional area of a single leg of a stirrup bar."]
[]
["Section 8.","The resistance factor input is the material resistance factors and the nodal interface factors. The resistance factors are based on Clause 5.5.4.2 of AASHTO LRFD 2017. Similarly, the nodal compressive strength multiplier for back and bearing face are based on Clause 5.8.2.2 of AASHTO LRFD 2017. These factors can be updated with the new edition of code."]
[]
[]
[]
["Section 9.","Reinforcement Details:"]
[null,"Longitudinal Reinforcement: The flexural reinforcement refers to the longitudinal reinforcement. The input should be made for each region because the reinforcement may not be constant throughout the beam. While inputting, be aware of the rebar change locations. The input includes the total area of top and bottom reinforcement and the centroidal distances of top reinforcement from top and bottom reinforcement from bottom of the beam.\nTransverse Reinforcement: The transverse reinforcement refers to the stirrups. Input the total number of legs and the spacing of the stirrups for each region."]
[]
[]
[]
[]
[]
[null,"Horizontal crack control reinforcement as shown in Fig. 5, is based on Clause 5.8.2.6 of AASHTO LRFD 2017. This reinforcement is intended to control the width of cracks and to ensure a minimum ductility for the member so that, if required, significant redistribution of internal stresses is possible. If no crack control reinforcement is provided, stress redistribution will be virtually impossible. . This clause is used to limit the diagonal crack width as a design requirement of strength and serviceability. The strength of the node faces are significantly affected if required amount of crack control reinforcement is not provided."]
[]
[]
[]
[]
[]
["Section 10.","This section needs input for bearing plate dimensions (Lb and Wb).\nBearing plate length or base plate length (Lb): This refers to the dimension of the plate parallel to the pier cap.\nBearing plate length or base plate width (Wb):  This refers to the dimension of the plate perpendicular to the pier cap."]
[]
[]
[]
[]
["Section 11.","The development length is calculated in reference to AASHTO code.  The development length calculation for straight bar follows Clause 5.10.8.2.1 of AASHTO LRFD 2017 while the development length for hook is based on Clause 5.10.8.2.4 of the same code. The development length is equal to basic development length times the modification factors. Fig. 6 explains the calculation procedure for the development length. \nFirst, the basic development length is calculated; then, it is multiplied with the modification factors . For modification factor, it asks Yes or No questions through pull-down menus to determine the modification factor.  \n"]
[]
[]
[]
[]
[]
[null,"If the rebar is not fully developed, the strength of rebar is multiplied by a factor, reinforcement capacity multiplier. It is the ratio of available development length to required development length."]
[]
[]
[]
["Section 12.","This section shows output model for the strut-and-tie analysis method. A sample output model is shown in Fig. 5. The model shown is color coded; 'Red' represents 'Tie' and 'Blue' represents 'Strut' and 'Intersection' represents 'Node'. The nodes are labelled. The utilization ratio (ratio of load to capacity or demand to capacity), is shown for critical strut and ties (not every elements) in the model."]
[]
[]
[]
[]
["Section 13.","This section shows the summary table for the strut and tie output model. \nMember Code: This refers to the name of the member from the output model. For example, B-F means a member from B to F.\nForce: These forces are the member forces in the truss model, as per the LRFD load combination, based on the load input in Section 4.\nCapacity: These capacities are the factored capacities in reference to AASHTO 2017which include resistance factors as input in Section 8.\nUtilization Ratio: This refers to the ratio of the 'load' to 'capacity' or 'demand' to 'capacity'. It shows if the member is overloaded or not. For example, a ratio of 0.74 means that the member is not overloaded and has approx. 26% of reserve capacity.\nThe utilization ratio for inclined and vertical members depends upon the strut and tie (STM) model, which changes according to the 'Use Vertical Tie' or 'Do not Use Vertical Tie' by inputting 1 or 0, respectively. Therefore, the user is provided the control over selecting the STM model. After this selection, press 'Re-Generate Output Model' to update the Sections 12 and 13.\nNOTE: Although an output section; it consists of input for supporting each inclined member with a vertical tie to refine the STM model.  The first input field for vertical tie corresponds to the usage of vertical tie at first inclined member and vice versa. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Section 15.","The different node types in the STM models are identified. And, based on the node types, the nodal compressive strength of bearing and back face are calculated as per Clause 5.8.2.5.3 of  AASHTO LRFD 2017."]
[]
[]
["Section 16.","The capacities for struts, ties and nodes are calculated based on Clause 5.8.2 of AASHTO LRFD 2017."]
[]
["Section 17.","This section deals with the member force calculation for each member of STM model. The matrix stiffness method is implemented to determine the STM member forces considering uniform member stiffness for each member. "]

{"sheet":"Appendix","index":2,"n_rows":136,"n_cols":22,"rows_kept":136,"cut":false,"hidden":true,"merged":[[29,20,29,21],[28,20,28,21],[23,12,23,14],[89,4,100,4],[77,2,77,3],[75,5,76,7],[75,8,75,9],[75,10,75,13],[74,0,74,19],[35,2,41,3],[48,2,54,3],[75,18,75,19],[77,4,88,4],[75,14,75,17],[38,14,38,15]]}
[]
[]
["Dropdown list for pier type"]
["Circular"]
["Square"]
[]
["Dropdown list for development length check"]
["Yes"]
["No"]
[]
["Development length formula for top and bottom bars (created for copying when required)"]
["Ld top, English unit:",null,"IF(E145>12*E144,IF(E144<=1.41,(MAX(1.25*(PI()*E144*E144/(4))*(D79)/SQRT(D78),0.4*E144*D79)),IF(E144<=1.7,2.7*(D79)/SQRT(D78),3.5*(D79)/SQRT(D78)))*1.4,MAX(38*(E144)/SQRT(D78)*(D79/60),6,8*E144))"]
["Ld top, SI unit:",null,"IF(E145>12*E144,IF(E144<=36,(MAX(1.25*(PI()*E144*E144/(4*645.16))*(D79/6.8947)/SQRT(D78/6.8947),0.4*E144*D79/(25.4*6.8947))),IF(E144<=43,2.7*(D79/6.8947)/SQRT(D78/6.8947),3.5*(D79/6.8947)/SQRT(D78/6.8947)))*1.4,MAX(38*(E144/25.4)/SQRT(D78/6.8947)*(D79/413.68),6,8*E144/25.4))*25.4"]
[]
["Ld bottom, English unit:",null,"IF(E159>12*E158,IF(E158<=1.41,(MAX(1.25*(PI()*E158*E158/(4))*(D79)/SQRT(D78),0.4*(E158)*(D79))),IF(E158<=1.7,2.7*(D79)/SQRT(D78),3.5*(D79)/SQRT(D78))),MAX(38*(E158)/SQRT(D78)*(D79/60),6,8*E158))"]
["Ld bottom, SI unit:",null,"IF(E159>12*E158,IF(E158<=36,(MAX(1.25*(PI()*E158*E158/(4*645.16))*(D79/6.8947)/SQRT(D78/6.8947),0.4*(E158/25.4)*(D79/6.8947))),IF(E158<=43,2.7*(D79/6.8947)/SQRT(D78/6.8947),3.5*(D79/6.8947)/SQRT(D78/6.8947))),MAX(38*(E158/25.4)/SQRT(D78/6.8947)*(D79/413.68),6,8*E158/25.4))*25.4"]
[]
[]
["Test cell for development length:",null,null,11,"[If first digit 1-> Top bar, Else if first digit 2-> Bottom bar][The second digit explains the regions: 1-> Cantilever part (Region 1); 2-> Region 2; 3->Region 3]"]
[]
["Calculated coordinate for each possible nodes",null,null,null,null,null,null,"Automatization of 'Generate Load Table' (the value are printed here and then converted to feet and inches)",null,null,null,null,null,null,null,null,null,null,"Test cell to hide the Utilization Ratio of top members when the load is at centerline"]
["Top","Bottom","Top & Bottom \"When Used Tie\"",null,null,null,null,"Cum. Inches",null,"Distance Inches",null,null,null,null,null,null,null,null,{"$f":"IF(AND(ABS(Analysis!H29-Analysis!E57)<0.01*Analysis!H29,Analysis!G9=1),1,0)","v":0}]
[{"$f":"Analysis!C52","v":22.4},{"$f":"Analysis!G52","v":43.620178041543028},{"$f":"(Analysis!C52+Analysis!G52)/2","v":33.010089020771517},null,null,null,null,22.375,{"$f":"H23","v":22.375},{"$f":"I23","v":22.375},null,null,null,null,null,null,null,null,{"$f":"IF(AND(ABS(Analysis!H29-Analysis!E57)<0.01*Analysis!H29,Analysis!G9=3),1,0)","v":0}]
[{"$f":"Analysis!C53","v":22.4},{"$f":"Analysis!G53","v":43.620178041543028},{"$f":"(Analysis!C53+Analysis!G53)/2","v":33.010089020771517},null,null,null,null,0,{"$f":"IF(H24=0,H24+I23,H24)","v":22.375},{"$f":"I24-I23","v":0},null,null,"Asymmetrical",null,null,null,null,null,{"$f":"IF(AND(ABS(Analysis!H29-Analysis!E57)<0.01*Analysis!H29,Analysis!G9=5),1,0)","v":0}]
[{"$f":"Analysis!C54","v":186.4},{"$f":"Analysis!G54","v":61.620178041543028},{"$f":"(Analysis!C54+Analysis!G54)/2","v":124.01008902077152},null,null,null,null,186.375,186.375,164,null,null,null,false,null,null,null,null,{"$f":"IF(AND(ABS(Analysis!H29-Analysis!E57)<0.01*Analysis!H29,Analysis!G9=7),1,0)","v":0}]
[{"$f":"Analysis!C55","v":186.4},{"$f":"Analysis!G55","v":241.27570093457945},{"$f":"(Analysis!C55+Analysis!G55)/2","v":213.83785046728974},null,null,null,null,0,186.375,0]
[{"$f":"Analysis!C56","v":186.4},{"$f":"Analysis!G56","v":241.27570093457945},{"$f":"(Analysis!C56+Analysis!G56)/2","v":213.83785046728974},null,null,null,null,0,186.375,0,null,null,null,"Check if load is at centerline or not"]
[{"$f":"Analysis!C57","v":350.4},{"$f":"Analysis!G57","v":259.27570093457945},{"$f":"(Analysis!C57+Analysis!G57)/2","v":304.83785046728974},null,null,null,null,350.375,350.375,164,null,null,null,{"$f":"IF(ABS(H29-E57)<0.01*H29,1,0)","v":0}]
[{"$f":"Analysis!E52","v":350.4},{"$f":"Analysis!I52","v":259.27570093457945},{"$f":"(Analysis!E52+Analysis!I52)/2","v":304.83785046728974},null,null,null,null,0,350.375,0,null,null,null,null,null,null,null,null,null,null,"Column Check"]
[{"$f":"Analysis!E53","v":350.4},{"$f":"Analysis!I53","v":259.27570093457945},{"$f":"(Analysis!E53+Analysis!I53)/2","v":304.83785046728974},null,null,null,null,0,350.375,0,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(T30=1, \"Circular\", \"Square\")","v":"Circular"}]
[{"$f":"Analysis!E54","v":350.4},{"$f":"Analysis!I54","v":259.27570093457945},{"$f":"(Analysis!E54+Analysis!I54)/2","v":304.83785046728974},null,null,null,null,0,350.375,0,null,null,null,"Sum of Total Pier Cap Length"]
[{"$f":"Analysis!E55","v":350.4},{"$f":"Analysis!I55","v":259.27570093457945},{"$f":"(Analysis!E55+Analysis!I55)/2","v":304.83785046728974},null,null,null,null,0,350.375,0,null,null,null,{"$f":"SUM(Analysis!I16:I20)","v":354}]
[{"$f":"Analysis!E56","v":350.4},{"$f":"Analysis!I56","v":259.27570093457945},{"$f":"(Analysis!E56+Analysis!I56)/2","v":304.83785046728974},null,null,null,null,0,350.375,0,null,null,null,"Sum of Total Load Length"]
[{"$f":"Analysis!E57","v":350.4},{"$f":"Analysis!I57","v":259.27570093457945},{"$f":"(Analysis!E57+Analysis!I57)/2","v":304.83785046728974},null,null,null,null,0,350.375,0,null,null,null,{"$f":"SUM(Analysis!F37:F48)","v":350.4}]
[]
[{"$f":"IF(Analysis!C217=1,\"Use Tie\", \"Do not use Tie\")","v":"Do not use Tie"},null,"Vertical Tie Text (Developed based on 1 and 0; for input and computational convenience)"]
[{"$f":"IF(Analysis!C219=1,\"Use Tie\", \"Do not use Tie\")","v":"Do not use Tie"},null,null,null,null,null,null,"Reaction (stored as string to print for output drawing)"]
[{"$f":"IF(Analysis!C221=1,\"Use Tie\", \"Do not use Tie\")","v":"Do not use Tie"},null,null,null,null,null,null,"B2",{"$f":"ROUND(Appendix!B79,0)","v":400}]
[{"$f":"IF(Analysis!C223=1,\"Use Tie\", \"Do not use Tie\")","v":"Do not use Tie"},null,null,null,null,null,null,"B4",{"$f":"ROUND(Appendix!B80,0)","v":0},null,null,null,null,null,"M-Factor"]
[{"$f":"IF(Analysis!C225=1,\"Use Tie\", \"Do not use Tie\")","v":"Do not use Tie"},null,null,null,null,null,null,"B6",{"$f":"ROUND(Appendix!B81,0)","v":106},null,null,null,null,null,"Depth",{"$f":"(Analysis!G23-Analysis!F123)/4","v":3.75}]
[{"$f":"IF(Analysis!C227=1,\"Use Tie\", \"Do not use Tie\")","v":"Do not use Tie"},null,null,null,null,null,null,"B8",{"$f":"ROUND(Appendix!B82,0)","v":294},null,null,null,null,null,"M-Factor",{"$f":"MIN(SQRT((Analysis!F122+4*P40)*(Analysis!F123+4*P40)/(Analysis!F122*Analysis!F123)),2)","v":1.8224786888818678}]
[{"$f":"IF(Analysis!C229=1,\"Use Tie\", \"Do not use Tie\")","v":"Do not use Tie"},null,null,null,0,null,null,"B10",{"$f":"ROUND(Appendix!B83,0)","v":0}]
[{"$f":"IF(Analysis!C231=1,\"Use Tie\", \"Do not use Tie\")","v":"Do not use Tie"},null,0,0,0,null,null,"B12",{"$f":"ROUND(Appendix!B84,0)","v":200}]
[{"$f":"IF(Analysis!C233=1,\"Use Tie\", \"Do not use Tie\")","v":"Do not use Tie"},null,0,0,0,null,null,"B14",{"$f":"ROUND(Appendix!B85,0)","v":0}]
[{"$f":"IF(Analysis!C235=1,\"Use Tie\", \"Do not use Tie\")","v":"Do not use Tie"},null,0,0,0,null,null,"B16",{"$f":"ROUND(Appendix!B86,0)","v":0}]
[{"$f":"IF(Analysis!C237=1,\"Use Tie\", \"Do not use Tie\")","v":"Do not use Tie"},null,0,0,0,null,null,"B18",{"$f":"ROUND(Appendix!B87,0)","v":0}]
[{"$f":"IF(Analysis!C239=1,\"Use Tie\", \"Do not use Tie\")","v":"Do not use Tie"},null,0,0,0,null,null,"B20",{"$f":"ROUND(Appendix!B88,0)","v":0}]
[null,null,0,0,0,null,null,"B22",{"$f":"ROUND(Appendix!B89,0)","v":0}]
["Top Nodes","Bottom Nodes","Nodes Name Database (Used to read required alphanumeric node name)",null,null,null,null,"B24",{"$f":"ROUND(Appendix!B90,0)","v":0}]
["A",1]
["B",2]
["C",3]
["D",4]
["E",5]
["F",6]
["G",7]
["H",8]
["I",9]
["J",10]
["K",11]
["L",12]
["M",13]
["N",14]
["O",15]
["P",16]
["Q",17]
["R",18]
["S",19]
["T",20]
["U",21]
["V",22]
["W",23]
["X",24]
[]
["MEMBER FORCES CALCULATED FROM THE OUTPUT REACTIONS OF STIFFNESS METHOD (Member forces mathches the stiffness method member force)"]
[null,null,null,null,null,"Angle with top horizontal member",null,null,"Inclined member",null,"Top member",null,null,null,"Bottom member",null,null,null,"Vertical member (Tie)",null,"Columns>",{"$f":"IF(N25=TRUE,2*Analysis!G9,Analysis!G9)","v":4}]
[null,null,null,null,null,null,null,null,"Member","Forces","Member","Forces","Member","Forces","Member","Forces","Member","Forces","Member","Forces"]
["Corresponding Reaction Forces",null,"Support Proportioning",null,"With Vertical Ties","θA  (=θB)",{"$f":"IF(Analysis!C37=0,0,ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/(0.5*(Analysis!C52-(Analysis!F25+Appendix!D79/2)))))","v":-1.3012178290012415},{"$f":"G78*180/PI()","v":-74.554289828946793},"A-1/B-2",{"$f":"IF(G78=0,0,-1*ABS(Appendix!B79/SIN(G78)))","v":-414.98802340962368},"A-B",{"$f":"IF(G78<0,-J78*COS(G78),J78*COS(G78))","v":110.52176063303662},"B-C",{"$f":"IF(G78<0,L78-J78*COS(G78),L78+J78*COS(G78))","v":221.04352126607324},"1-2",{"$f":"IF(G78<0,+J78*COS(G78),-J78*COS(G78))","v":-110.52176063303662},"2-3",{"$f":"IF(G78<0,P78+J78*COS(G78),P78-J78*COS(G78))","v":-221.04352126607324},"B-1",{"$f":"Appendix!B79","v":400.00000000000017},"B1",{"$f":"IF(AND(B79=0,B80=0,B81=0),0,B79/(B79+B80+B81)*Analysis!G21)","v":28.46751477273196}]
["F2",400.00000000000017,"B1",{"$f":"Analysis!C301","v":27.240356083086056},null,"θC  (=θD)",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/(0.5*(Analysis!C53-(Analysis!F25+Appendix!D79+Appendix!D80/2))))","v":-1.1449108175995832},{"$f":"DEGREES(G79)","v":-65.598557767328529},"C-3/D-4",{"$f":"-1*ABS(Appendix!B80/SIN(G79))","v":0},"C-D",{"$f":"IF(G79<0,N78-J79*COS(G79),N78+J79*COS(G79))","v":221.04352126607324},"D-F",221.04352126607324,"3-4",{"$f":"IF(G79<0,R78+J79*COS(G79),R78-J79*COS(G79))","v":-221.04352126607324},"4-6",-221.04352126607324,"D-3",{"$f":"Appendix!B80","v":0},"B2",{"$f":"IF(AND(B79=0,B80=0,B81=0),0,B80/(B79+B80+B81)*Analysis!G21)","v":0}]
["F4",0,"B2",{"$f":"Analysis!C302","v":0},null,"θE  (=θF)",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/(0.5*(Analysis!C54-(Analysis!F25+Analysis!G21-Appendix!D81/2))))","v":0.55172715852321641},31.611637626125624,"E-5/F-6",{"$f":"-1*ABS(Appendix!B81/SIN(G80))","v":-201.92298894986035},"F-E",49.08176703299452,"E-G",-122.8799872000842,"6-5",{"$f":"IF(G80<0,R79+J80*COS(G80),R79-J80*COS(G80))","v":-49.08176703299452},"5-7",122.8799872000842,"F-5",{"$f":"Appendix!B81","v":105.83973047739521},"B3",{"$f":"IF(AND(B79=0,B80=0,B81=0),0,B81/(B79+B80+B81)*Analysis!G21)","v":7.5324852272680394}]
["F6",105.83973047739521,"B3",{"$f":"Analysis!C303","v":8.7596439169139444},null,"θG  (=θH)",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/(0.5*(Analysis!C55-(Analysis!F26+Appendix!D82/2))))","v":-0.95038685315205695},-54.4531555903324,"G-7/H-8",{"$f":"-1*ABS(Appendix!B82/SIN(G81))","v":-361.53593684350039},"G-H",87.30557239832396,"H-I",297.49113199673212,"7-8",-87.30557239832396,"8-9",-297.49113199673212,"H-7",{"$f":"Appendix!B82","v":294.16026952260484},"B4",{"$f":"IF(AND(B82=0,B83=0,B84=0),0,IF(V76=3,B82/(B82+B83)*(Analysis!G21/2),B82/(B82+B83+B84)*Analysis!G21))","v":21.429828247916912}]
["F8",294.16026952260484,"B4",{"$f":"Analysis!C304","v":14.551401869158878},null,"θI  (=θJ)",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/(0.5*(Analysis!C56-(Analysis!F26+Appendix!D82+Appendix!D83/2))))","v":-0.89043265246371162},-51.01803292680988,"I-9/J-10",{"$f":"-1*ABS(Appendix!B83/SIN(G82))","v":0},"I-J",297.49113199673212,"J-L",297.49113199673212,"9-10",-297.49113199673212,"10-12",-297.49113199673212,"J-9",{"$f":"Appendix!B83","v":0},"B5",{"$f":"IF(AND(B82=0,B83=0,B84=0),0,IF(V76=3,B83/(B82+B83)*(Analysis!G21/2),B83/(B82+B83+B84)*Analysis!G21))","v":0}]
["F10",0,"B5",{"$f":"Analysis!C305","v":0},null,"θK  (=θL)",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/(0.5*(Analysis!C57-(Analysis!F26+Analysis!G21-Appendix!D84/2))))","v":0.7003020415874367},40.124351367355182,"L-12/K-11",{"$f":"-1*ABS(Appendix!B84/SIN(G83))","v":-310.34279173900762},"L-K",60.188269847198285,"K-M",-177.11459230233555,"12-11",-60.188269847198285,"11-13",177.11459230233555,"L-11",{"$f":"Appendix!B84","v":200.00000000000099},"B6",{"$f":"IF(AND(B82=0,B83=0,B84=0),0,B84/(B82+B83+B84)*Analysis!G21)","v":14.570171752083086}]
["F12",200.00000000000099,"B6",{"$f":"Analysis!C306","v":21.448598130841123},null,"θM  (=θN)",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/(0.5*(Analysis!E52-(Analysis!F27+Appendix!D85/2))))","v":1.3854483767992021},79.380344723844885,"M-13/N-14",{"$f":"-1*ABS(Appendix!B85/SIN(G84))","v":0},"M-N",-177.11459230233555,"N-O",-177.11459230233555,"13-14",177.11459230233555,"14-15",177.11459230233555,"N-13",{"$f":"Appendix!B85","v":0},"B7",{"$f":"IF(AND(B85=0,B86=0,B87=0),0,IF(V76=5,B85/(B85+B86)*(Analysis!G21/2),B85/(B85+B86+B87)*Analysis!G21))","v":0}]
["F14",0,"B7",{"$f":"Analysis!C307","v":0},null,"θO  (=θP)",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/(0.5*(Analysis!E53-(Analysis!F27+Appendix!D85+Appendix!D86/2))))","v":1.3854483767992021},79.380344723844885,"O-15/P-16",{"$f":"-1*ABS(Appendix!B86/SIN(G85))","v":0},"0-P",-177.11459230233555,"P-R",-177.11459230233555,"15-16",177.11459230233555,"16-18",177.11459230233555,"P-15",{"$f":"Appendix!B86","v":0},"B8",{"$f":"IF(AND(B85=0,B86=0,B87=0),0,IF(V76=5,B86/(B85+B86)*(Analysis!G21/2),B86/(B85+B86+B87)*Analysis!G21))","v":0}]
["F16",0,"B8",{"$f":"Analysis!C308","v":0},null,"θQ  (=θR)",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/(0.5*(Analysis!E54-(Analysis!F27+Analysis!G21-Appendix!D87/2))))","v":-1.2966288756752375},-74.291362170984243,"R-18/Q-17",{"$f":"-1*ABS(Appendix!B87/SIN(G86))","v":0},"R-Q",-177.11459230233555,"Q-S",-177.11459230233555,"18-17",177.11459230233555,"17-19",177.11459230233555,"R-17",{"$f":"Appendix!B87","v":0},"B9",{"$f":"IF(AND(B85=0,B86=0,B87=0),0,B87/(B85+B86+B87)*Analysis!G21)","v":0}]
["F18",0,"B9",{"$f":"Analysis!C309","v":0},null,"θS  (=θT)",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/(0.5*(Analysis!E55-(Analysis!F28+Appendix!D88/2))))","v":1.3854483767992021},79.380344723844885,"S-19/T-20",{"$f":"-1*ABS(Appendix!B88/SIN(G87))","v":0},"S-T",-177.11459230233555,"T-U",-177.11459230233555,"19-20",177.11459230233555,"20-21",177.11459230233555,"T-19",{"$f":"Appendix!B88","v":0},"B10",{"$f":"IF(AND(B88=0,B89=0,B90=0),0,IF(V76=7,B88/(B88+B89)*(Analysis!G21/2),B88/(B88+B89+B90)*Analysis!G21))","v":0}]
["F20",0,"B10",{"$f":"Analysis!C310","v":0},null,"θU  (=θV)",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/(0.5*(Analysis!E56-(Analysis!F28+Appendix!D88+Appendix!D89/2))))","v":1.3854483767992021},79.380344723844885,"U-21/V-22",{"$f":"-1*ABS(Appendix!B89/SIN(G88))","v":0},"U-V",-177.11459230233555,"V-X",-177.11459230233555,"21-22",177.11459230233555,"22-24",177.11459230233555,"V-21",{"$f":"Appendix!B89","v":0},"B11",{"$f":"IF(AND(B88=0,B89=0,B90=0),0,IF(V76=5,B89/(B88+B89)*(Analysis!G21/2),B89/(B88+B89+B90)*Analysis!G21))","v":0}]
["F22",0,"B11",{"$f":"Analysis!C311","v":0},null,"θW  (=θX)",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/(0.5*(Analysis!E57-(Analysis!F28+Analysis!G21-Appendix!D90/2))))","v":-1.2966288756752375},-74.291362170984243,"X-24/W-23",{"$f":"-1*ABS(Appendix!B90/SIN(G89))","v":0},"X-W",-177.11459230233555,"W+",-177.11459230233555,"24-23",177.11459230233555,"24+",177.11459230233555,"X-23",{"$f":"Appendix!B90","v":0},"B12",{"$f":"IF(AND(B88=0,B89=0,B90=0),0,B90/(B88+B89+B90)*Analysis!G21)","v":0}]
["F24",0,"B12",{"$f":"Analysis!C312","v":0},"Without Vertical Ties","θA ",{"$f":"IF(Analysis!C37=0,0,ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/((Analysis!C52-(Analysis!F25+Appendix!D79/2)))))","v":-1.0659524026405884},-61.074573833135503,"A-2",{"$f":"IF(G90=0,0,-1*ABS(Appendix!B79/SIN(G90)))","v":-457.01229556074867},"A-C",{"$f":"N78","v":221.04352126607324},null,null,"2-4",{"$f":"R78","v":-221.04352126607324}]
[null,null,null,null,null,"θC ",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/((Analysis!C53-(Analysis!F25+Appendix!D79+Appendix!D80/2))))","v":-0.83396216879006946},-47.782512545247762,"C-4",{"$f":"-1*ABS(Appendix!B80/SIN(G91))","v":0},"C-E",221.04352126607324,null,null,"4-6",-221.04352126607324]
[null,null,null,null,null,"θE ",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/((Analysis!C54-(Analysis!F25+Analysis!G21-Appendix!D81/2))))","v":0.29854438433901398},17.105333219957053,"E-6",{"$f":"-1*ABS(Appendix!B81/SIN(G92))","v":-359.84083734784576},"E-G",-122.8799872000842,null,null,"6-8",122.8799872000842]
[null,null,null,null,null,"θG ",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/((Analysis!C55-(Analysis!F26+Appendix!D82/2))))","v":-0.61056706838626595},-34.982916128208551,"G-8",{"$f":"-1*ABS(Appendix!B82/SIN(G93))","v":-513.07128356632427},"G-I",297.49113199673212,null,null,"8-10",-297.49113199673212]
[null,null,null,null,null,"θI",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/((Analysis!C56-(Analysis!F26+Appendix!D82+Appendix!D83/2))))","v":-0.55343837528934936},-31.709683124657069,"I-10",{"$f":"-1*ABS(Appendix!B83/SIN(G94))","v":0},"I-K",297.49113199673212,null,null,"10-12",-297.49113199673212]
[null,null,null,null,null,"θK ",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/((Analysis!C57-(Analysis!F26+Analysis!G21-Appendix!D84/2))))","v":0.39881952152343014},22.850675370719443,"K-12",{"$f":"-1*ABS(Appendix!B84/SIN(G95))","v":-515.02484749518931},"K-M",-177.11459230233555,null,null,"12-14",177.11459230233555]
[null,null,null,null,null,"θM  ",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/((Analysis!E52-(Analysis!F27+Appendix!D85/2))))","v":1.212025656524325},69.443954780416576,"M-14",{"$f":"-1*ABS(Appendix!B85/SIN(G96))","v":0},"M-O",-177.11459230233555,null,null,"14-16",177.11459230233555]
[null,null,null,null,null,"θO ",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/((Analysis!E53-(Analysis!F27+Appendix!D85+Appendix!D86/2))))","v":1.212025656524325},69.443954780416576,"O-16",{"$f":"-1*ABS(Appendix!B86/SIN(G97))","v":0},"O-Q",-177.11459230233555,null,null,"16-18",177.11459230233555]
[null,null,null,null,null,"θQ ",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/((Analysis!E54-(Analysis!F27+Analysis!G21-Appendix!D87/2))))","v":-1.0584068664841584},-60.642246457208699,"Q-18",{"$f":"-1*ABS(Appendix!B87/SIN(G98))","v":0},"Q-S",-177.11459230233555,null,null,"18-20",177.11459230233555]
[null,null,null,null,null,"θS  ",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/((Analysis!E55-(Analysis!F28+Appendix!D88/2))))","v":1.212025656524325},69.443954780416576,"S-20",{"$f":"-1*ABS(Appendix!B88/SIN(G99))","v":0},"S-U",-177.11459230233555,null,null,"20-22",177.11459230233555]
[null,null,null,null,null,"θU ",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/((Analysis!E56-(Analysis!F28+Appendix!D88+Appendix!D89/2))))","v":1.212025656524325},69.443954780416576,"U-22",{"$f":"-1*ABS(Appendix!B89/SIN(G100))","v":0},"U-W",-177.11459230233555,null,null,"22-24",177.11459230233555]
[null,null,null,null,null,"θW ",{"$f":"ATAN((Analysis!G22-Analysis!D297/2-Analysis!D298/2)/((Analysis!E57-(Analysis!F28+Analysis!G21-Appendix!D90/2))))","v":-1.0584068664841584},-60.642246457208699,"W-24",{"$f":"-1*ABS(Appendix!B90/SIN(G101))","v":0},"W+",-177.11459230233555,null,null,"24+",177.11459230233555]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Warning Checks"]
[null,{"$f":"Analysis!G16","v":4},{"$f":"Analysis!H16","v":0}]
[null,{"$f":"Analysis!G17","v":17},{"$f":"Analysis!H17","v":0}]
[null,{"$f":"Analysis!G18","v":8},{"$f":"Analysis!H18","v":6}]
[null,{"$f":"Analysis!G19","v":0},{"$f":"Analysis!H19","v":0}]
[null,{"$f":"Analysis!G20","v":0},{"$f":"Analysis!H20","v":0}]
[null,{"$f":"Analysis!G21","v":36}]
[null,{"$f":"Analysis!G22","v":48.4}]
[null,{"$f":"Analysis!G23","v":36}]

{"sheet":"Rebar Area & Centroid","index":3,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,1,23,3],[1,1,1,4],[13,1,13,4],[10,1,10,3],[11,1,11,3],[22,1,22,3]]}
[]
[null,"Top Bars"]
[null,"Layer","Bar Area","No.of Bar","Distance"]
[null,"Layer1 ",1,6,3]
[null,"Layer2",1,6,7]
[null,"Layer3"]
[null,"Layer4"]
[null,"Layer5"]
[null,"Layer6"]
[null,"Layer7"]
[null,"Total top steel",null,null,{"$f":"C4*D4+C5*D5+C6*D6+C7*D7+C8*D8+C9*D9+C10*D10","v":12}]
[null,"Centroid from top of section",null,null,{"$f":"(C4*D4*E4+C5*D5*E5+C6*D6*E6+C7*D7*E7+C8*D8*E8+C9*D9*E9+C10*D10*E10)/E11","v":5}]
[]
[null,"Bottom Bars"]
[null,"Layer","Bar Area","No.of Bar","Distance"]
[null,"Layer1 ",1.27,7,4]
[null,"Layer2",1.27,4,8]
[null,"Layer3"]
[null,"Layer4"]
[null,"Layer5"]
[null,"Layer6"]
[null,"Layer7"]
[null,"Total bottom steel",null,null,{"$f":"C16*D16+C17*D17+C18*D18+C19*D19+C20*D20+C21*D21+C22*D22","v":13.97}]
[null,"Centroid from bottom of section",null,null,{"$f":"(C16*D16*E16+C17*D17*E17+C18*D18*E18+C19*D19*E19+C20*D20*E20+C21*D21*E21+C22*D22*E22)/E23","v":5.4545454545454541}]

{"sheet":"About","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"!! Hide this!!-Input_info_model","index":5,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":true,"merged":[[17,9,28,9],[16,1,16,2],[16,3,16,4],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[15,1,15,5],[6,1,6,5],[1,1,1,8],[3,1,3,6],[4,1,4,5],[5,1,5,5],[3,9,3,14],[4,9,4,13],[5,9,5,13],[6,9,6,13],[7,9,7,13]]}
[]
[null,"Analysis Input"]
[]
[null,"Geometry Details for Sample Input Drawing",null,null,null,null,null,null,null,"Cumulative Distance of Column Edge From Left Pier (E, var)"]
[null,"Distance from start of the pier cap to center of first column (C1)",null,null,null,null,2000,"C1",null,"Distance from Tip of Cantilever to near edge of 1st Pier",null,null,null,null,{"$f":"G5-G10/2","v":1550}]
[null,"Distance from center of first column to center of second column (C2)",null,null,null,null,4000,"C2",null,"Distance from Tip of Cantilever to near edge of 1st Pier",null,null,null,null,{"$f":"G5+G6-G10/2","v":5550}]
[null,"Distance from center of second column to center of third column (C3)",null,null,null,null,4000,"C3",null,"Distance from Tip of Cantilever to near edge of 1st Pier",null,null,null,null,{"$f":"O6+G7","v":9550}]
[null,"Distance from center of third column to center of fourth column (C4)",null,null,null,null,4000,"C4",null,"Distance from Tip of Cantilever to near edge of 1st Pier",null,null,null,null,{"$f":"O7+G8","v":13550}]
[null,"Distance from center of fourth column to center line of section (C5)",null,null,null,null,2000,"C5"]
[null,"Column width (W)",null,null,null,null,900,"W"]
[null,"Depth of pier cap (h)",null,null,null,null,1200,"h"]
[null,"Thickness of pier cap (t)",null,null,null,null,900,"t"]
[]
[null,null,null,null,null,"Approx. Effective depth of Pier-Cap (d=0.9*h)",{"$f":"0.9*G11","v":1080}]
[]
[null,"Sample Ultimate Loads and Their Position"]
[null,"Load",null,"Distance",null,"Region Text"]
[null,"P1",1146,400,"A1","R1",null,null,null,"Distance of Load from the edge of the pier cap","D1",{"$f":"D18","v":400}]
[null,"P2",1146,1500,"A2","R2",null,null,null,null,"D2",{"$f":"L18+D19","v":1900}]
[null,"P3",1146,1333,"A3","R3",null,null,null,null,"D3",3233]
[null,"P4",1146,1333,"A4","R4",null,null,null,null,"D4",4566]
[null,"P5",1146,1333,"A5","R5",null,null,null,null,"D5",5899]
[null,"P6",1146,1333,"A6","R6",null,null,null,null,"D6",7232]
[null,"P7",1146,1333,"A7","R7",null,null,null,null,"D7",8565]
[null,"P8",1146,1333,"A8","R8",null,null,null,null,"D8",9898]
[null,"P9",1146,1333,"A9","R9",null,null,null,null,"D9",11231]
[null,"P10",1146,1333,"A10","R10",null,null,null,null,"D10",12564]
[null,"P11",1146,1333,"A11","R11",null,null,null,null,"D11",13897]
[null,"P12",1146,1333,"A12","R12",null,null,null,null,"D12",15230]
[null,null,null,null,null,"R13"]